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 ,
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 ,
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 ,