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.
Here, A3:A9 is referencing the range, and E5 references the criteria.
- Select the F5 cell.
- Write the formula above.
- Now, select the E5 cell.
- Write a query and hit the Enter Key.
That concludes the session. This post helped you count unique Excel values depending on specified criteria.