Lets take a look at a few more cool examples. COUNTIFA2A10 F1 COUNTIFA2A10 G1 This technique works fine for a couple of criteria but adding three or more COUNTIF functions together would make the formula too cumbersome. If we wish to count based on certain criteria then we should use COUNTIF.
The named range Ages refers to the range A1A6.
Criteria specifies the condition that a particular cell content should meet to be counted. COUNT COUNTA COUNTBLANK COUNTIF and COUNTIFS. Excel has many functions where a user needs to specify a single or multiple criteria to get the result. With the example shown COUNTIFS can be used to count records using 2 criteria as follows.