How to count unique values based on criteria using COUNTIF in Excel

How to count unique values based on criteria using COUNTIF in Excel

This article will discuss a simple method to count unique values based on criteria in Excel. In the following dataset, we have a list of T20 World Cup-winning countries since 2007. We aim to find how many times a country got the world cup from the list.

 

First, we will create a formula using the COUNTIF function.

Formula:

 =COUNTIF(A3:A9,E5) 

Here, A3:A9 is referencing the range, and E5 references the criteria.

Steps:

  1. Select the F5 cell.
  2. Write the formula above.
  3. Now, select the E5 cell.
  4. Write a query and hit the Enter Key.

That concludes the session. This post helped you count unique Excel values depending on specified criteria.

We will be happy to hear your thoughts

Leave a reply

Bike Spree
Logo
Enable registration in settings - general
Compare items
  • Total (0)
Compare
0