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.

IMPORTANT This update is not needed and will not be offered if your Windows Recovery Environment (WinRE) meets any of the following conditions: If the WinRE recovery partition does not have sufficient free space.

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.

Select the temporary files, unused files, files synced to the cloud, or unused apps you want to remove, then select the Clean up button for each section.

Notes: To find an item in the Choose commands from list, it may be helpful to first confirm its location and name within the app. Commands that are no longer visible in the app could still be listed here under All commands.To help identify this type of command, a more descriptive tooltip name may appear in parentheses next to the legacy command name in this form:

Before you set up an out of office or automatic reply in Outlook, you'll need to know your Outlook account type. The steps you'll follow will depend on whether you have a Microsoft Exchange Outlook email account (if you have email through an organization, such as the place where you work) or an IMAP or POP3 account (if you have an individual email account such as Yahoo or Gmail).

If you weren't able to change your password. If you couldn't change your password this way, see Reset your Microsoft account password. Need more help? Contact Support. For technical support, go to Contact Microsoft Support, enter your problem and select Get Help.If you still need help, select Contact Support to be routed to the best support option.

Learn how to open and run DxDiag.exe on Windows to collect device information and troubleshoot DirectX sound and video issues.

Step 2: Back up your folders. Windows Backup is an easy, single stop for all of your backup needs. Your free Microsoft account comes with 5 GB of OneDrive cloud storage (and more storage is available if you need it), and backing up your folders syncs the folders you specify to your OneDrive account, making them instantly accessible on all computers that you use with this Microsoft account.

Learn how to run Windows Update Troubleshooter to resolve errors downloading or installing Windows updates.