Argument name. Description. range (required). The group of cells you want to count. Range can contain numbers, arrays, a named range, or references that contain numbers. Blank and text values are ignored. Learn how to select ranges in a worksheet.. criteria (required). A number, expression, cell reference, or text string that determines which cells will be counted.

Use System restore to make restore points when you install a new app, driver, or Windows update, and when you create a restore point manually.

sum_range Optional.The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).. Sum_range should be the same size and shape as range.If it isn't, performance may suffer, and the formula will sum a range of ...

Receive photos, videos, or other kinds of files that you or a friend shares from another device, such as a phone, laptop, or tablet. On your PC, select Start > Settings > Devices > Bluetooth & other devices. Learn how to pair.

Learn how to download, install, and use the PC Health Check app to check your device's compatibility with Windows 11 and get tips to improve its performance.

IMAP and POP are two methods to access email. IMAP is the recommended method when you need to check your emails from several different devices, such as a phone, laptop, and tablet.

Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.

Learn how to remove malware from your PC. Use Microsoft Defender Antivirus in Windows 10 or Windows 11 to scan your PC for malware, viruses, or other threats.

To adjust power and sleep settings in Windows 10, go to Start , and select Settings > System > Power & sleep.. Under Screen, select how long you want your device to wait before turning the screen off when you're not using your device.

Important: The following steps apply only to devices currently running an activated copy of Windows 11 Home.If you’re not activated, we recommend you activate Windows 11 Home first. For more info, see Activate Windows.