If you have a list of data and would like to find out how many of 1 value there are. For example if you have a column of product number you can Find out how many of product #1234 are in the column.
Image: digitalart / FreeDigitalPhotos.net
By using the function Countif Microsoft Excel will count or a specific condition or value.
= Countif (range, condition)
If my product column is column c then my calculation could look like this:
= Countif (C2:C400, “1234”)
The criteria could also be a reference to a cell that contains the criteria.
= Countif (C2:C400, A2)
I use this two different ways, one is to find out how many items I have of uniques, usually using an advanced filter to extract a list of the unique items first, then the countif to find out how many of each. The other way I use this is to find out if I have any duplicates.
How do you use the countif function?