Excel Function : COUNTIFS
Category
Statistical
Description
Counts the number of cells within a range that meet multiple criteria
Microsoft Excel Reference Page
https://support.office.com/en-us/article/COUNTIFS-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842
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