If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF(B2:B5, "John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal "John." To sum cells based on multiple criteria, see SUMIFS function.

Create a booklet or book. Go to Layout and select the Page Setup dialog launch icon at the bottom-right corner. On the Margins tab, change the setting for Multiple pages to Book fold. The orientation automatically changes to Landscape. Tip: If you have a long document, you might want to split it into multiple booklets, which you can then bind ...

Step 1: Start an Office app, like Word, Project, or Visio, depending on your purchase. Step 2: In the Sign in to set up Office window, select I don't want to sign in or create an account (it's a small link at the bottom of the window). Step 3: Enter your Office product key, without hyphens. If you don't have your key, see get your Workplace ...

Create a booklet or book. Go to Layout and select the Page Setup dialog launch icon at the bottom-right corner. On the Margins tab, change the setting for Multiple pages to Book fold. The orientation automatically changes to Landscape. Tip: If you have a long document, you might want to split it into multiple booklets, which you can then bind ...

First, launch Windows Backup: select Start , type windows backup, and select Windows Backup from the results. (Or you can select Start > All apps > Windows Backup .) Then select Folders to drop it down, and select which of your user folders you want to back up to OneDrive: You can back up your Desktop, Documents, Pictures, Videos, and Music ...

This article applies if you’ve recently made changes to your device hardware and are trying to upgrade to Windows 11. Hardware changes might affect your upgrade eligibility, though you’ll need to take a few steps to see your updated eligibility in Settings.

To connect a wireless printer, follow these steps: Select Start > Settings > Bluetooth & devices > Printers & scanners . Open Printers & scanners settings. Next to Add a printer or scanner, select Add device. Wait for it to find nearby printers, then locate the one you want to use, and select Add device. If you want to remove the printer later ...

Follow the prompts to install or reinstall the desktop apps. For Microsoft 365 Family or Personal subscriptions: Select Install premium Microsoft 365 apps and follow the prompts to install or reinstall the desktop apps. On the Microsoft 365 subscription tab, select Manage. From here you can: Renew your subscription with a prepaid code or card.

To sign out, go to Outlook.com. Select your account initials or account picture at the top corner of your Inbox. Select Sign out. Tips: If you don't see your picture at the top of screen, check to see if ad blocking is turned on. Sometimes this prevents the picture from showing. If you don't see see Profile or Account options, you can access ...

To install Authenticator on your Android device. Scan the QR code. or download and install Authenticator from the Google Play store. Get the app.