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.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Important: You don't need to remove old security information unless there is an account security risk (e.g. someone else has access to your old mailbox).

Troubleshoot issues that occur when setting up external monitors. If you are trying to set up an external monitor and it’s not working, press the Windows logo key + P to make sure that the Extend option is selected. If the Extend option is selected, try the following troubleshooting tips.

We want to hear from you! Please continue to share your feedback with us — either in the Google Play Store, directly in the Phone Link and Link to Windows apps, or at the bottom of this article.

Dans la plupart des cas, il vous suffit de connecter le scanneur à votre appareil pour l’installer. Branchez le câble USB de votre scanneur sur un port USB disponible sur votre appareil, puis allumez le scanneur.

Add a contact from someone's profile card. If you're using Outlook in an organization and you click someone's name or picture in Outlook or other Office apps and services, you might see a profile card with additional information.

In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").

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.

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.