Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 820
  • Last Modified:

how many arguments does the countif funtion contain

how many arguments does the countif funtion contain
0
reed55
Asked:
reed55
  • 2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now