how many arguments does the countif funtion contain

how many arguments does the countif funtion contain
reed55Asked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Two.

=countif(range, criteria)

cheers, teylyn
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
In 2007 and later there's also the COUNTIFS() function

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

You can use up to 127 range/criteria pairs.

cheers, teylyn
0
All Courses

From novice to tech pro — start learning today.