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.

  • Last Updated Sep 24, 2018
  • Views 0
  • Answered By Daniel Wilson

FAQ Actions

Was this helpful? 0   0