Microsoft Excel Formulas – COUNTIF

October 27, 2013 Billy Aung Myint No comments

COUNTIF is basically a formula to count how many occurrence of a particular criteria that has been given. Its syntax is as follows

=COUNTIF(RANGE , CRITERIA)

An example , lets say we have a a few rows of numeric data ,

10
22
36
54
82
16
17

And you want to know how many of them are > 50 ,

The COUNTIF formula would be , =COUNTIF(C4:C10 , “>50”) , which will returns 2. The only two numbers that are more than 50 in that list are 54 and 82.

The reverse of that would be , =COUNTIF(C4:C10 , “<50”) , which will return 5.

COUNTIF can also be used on the text as well ,

smith
john
billy
mary
cheese
billy
alice

And you want to know how many of them are “billy” , the same thing

=COUNTIF(C4:C10 , “billy”) , which will returns 2.

Thanks for reading ,

Billy

 

 

Comments are closed.