Excel Guides

Counting Unique Values with Functions in Excel

Excel offers a few different ways to count unique values. The most common is the COUNTIF function. This function can be used to count cells that contain a specific value, or it can be used to count cells that meet certain criteria. For example, you could use the COUNTIF function to count the number of cells that contain the word "apple."

To use the COUNTIF function, you need to specify two arguments: the range of cells to check and the criterion. The criterion can be a specific value, or it can be a cell reference. For example, if you wanted to count the number of cells in column A that contain the word "apple," you would use the following formula:

=COUNTIF(A:A,"apple")

If you wanted to count the number of cells in column A that are greater than 10, you would use the following formula:

=COUNTIF(A:A,">10")

Note: The COUNTIF function is case-sensitive. So, if you're looking for a specific value, make sure to match the case of the value exactly.

Another way to count unique values is with the FREQUENCY function.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.