Excel Function : COUNTIFS

Download now!

Excel Function : COUNTIFS




Counts the number of cells within a range that meet multiple criteria

Microsoft Excel Reference Page


Syntax and Description of the COUNTIFS Excel Function

I get a syntax error when trying to use the COUNTIFS function. I'm trying to use COUNTIFS to count how many cells in the column contains 1 and 2 at the same time. =COUNTIFS(A1:A20,"1",A1:A20,"2") The above code gives me a syntax error. A: You can only use a single criteria in COUNTIFS, so you'll need to combine your criteria with an "OR" function. =COUNTIFS(A1:A20, "1

About COUNTIFS Excel Function

The COUNTIFS function in Excel counts the number of cells that meet multiple criteria. The syntax for the COUNTIFS function is as follows: =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...) where criteria_range1 is the first range of cells to be evaluated for the criteria1, criteria1 is the criterion that cells in criteria_range1 must meet, criteria_range2 is the second range of cells to be evaluated for the criteria2, and criteria2 is the criterion that cells in criteria_range2 must meet. Additional criteria_range/criteria pairs can be added as