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.

Generally, if you bought a physical copy of Windows, the product key should be on a label or card inside the box that Windows came in. If Windows came preinstalled on your PC, the product key should appear on a sticker on your device. If you’ve lost or can’t find the product key, contact the manufacturer. To ensure your product key is ...

Taskbar icon. Apps. Check your version of Teams. For Microsoft Teams (free), select Settings and more > Settings > About Teams , then look under Version to see if you have the latest version or need to Update now. For Microsoft Teams (work or school), select Settings and more > About, then look under Version.

A scanner you've connected using a wired, wireless, or network connection. An app for scanning files, such as Windows Scan, available for free from Microsoft Store. The Windows Scan app can help you scan pictures or documents and save them to your PC as JPEG, bitmap, or PNG files. For more info, see Install and use a scanner in Windows.

Install and use a scanner in Windows 10. Windows 10. When you connect a scanner to your device or add a new scanner to your home network, you can usually start scanning pictures and documents right away. If your scanner doesn't automatically install, here's some help to get things working. Select one of the following sections, or select Show all.

Type a date in Cell A1 and in cell B1, type the formula =EDATE(4/15/2013,-5). Here, we’re specifying the value of the start date entering a date enclosed in quotation marks. You can also just refer to a cell that contains a date value or by using the formula =EDATE(A1,-5)for the same result. More examples To add years to or subtract years ...

Chat or receive a call back from a technical support expert: If you have a Microsoft 365 Basic, Microsoft 365 Personal, or Microsoft 365 Family subscription, get questions answered from anywhere via chat or request to receive a call back from one of our technical support experts. See the table below for the type of support you can get depending ...

On the Shape Format tab, select Rotate. and choose a direction or angle to rotate. Grab the Rotation handle on the top of the text box and drag it to the angle you want. To keep the rotation to 15 degree angles, press and hold Shift while you drag the rotation handle. Select elsewhere on your document to view the rotated text box.

Select the cell in the worksheet where you want the drop-down list. Go to the Data tab on the Ribbon, and then Data Validation. Note: If you can’t select Data Validation, the worksheet might be protected or shared. Unlock specific areas of a protected workbook or stop sharing the worksheet, and then try step 3 again.

To turn on Windows Hello. Go to Start > Settings > Accounts > Sign-in options. Select the Windows Hello method that you want to set up, Select Set up. If you don't see Windows Hello in Sign-in options, then it may not be available for your device. Windows Hello does require a compatible camera or fingerprint reader.