Q. How do I use a COUNTIF formula in Microsoft Excel?
COUNTIF will count up the number of cells that meet a certain criteria. The syntax for typing up this formula is as follows: =COUNTIFS (range1, criteria1, [range2], [criteria2], ...). The range is the range of cells that you want. Example: C1:C16. You don’t have to have more than one range. The criteria is the criteria that the cell needs to have to be counted. For example: Apple, would count every cell that contains just the word Apple.