How to use COUNTIF and COUNTIFS in Microsoft Excel

Learn how to use COUNTIF and COUNTIFS to count the number of cells that meet a criterion or multiple conditions; for example, to count the number of times a particular city appears in a customer list.

  • In this video, I run through the following:
    1. Count how many times a certain string or number appear in a list
    2. Count how many times multiple items appear in a list
    3. Count how many items are greater than or less than a certain value
    4. Count how many items are between certain values
    5. Count how many items do not match certain values
    6. Count how many items begin or end with certain characters
    7. Count how many items match certain conditions across multiple columns

Lastly, I cover how to use Excel for free on the web. Excel on the web supports the COUNTIF and COUNTIFS functions. Here’s the sheet I used if you want to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whId2V…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s