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
2 at the same time.
The above code gives me a syntax error.
You can only use a single criteria in COUNTIFS, so you'll need to combine your criteria with an "OR" function.
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