May 17 2022 08:41 AM
I am trying to count how many employees are listed in one column as "CERT" and then in another column with a location name.
=countifs(CS375:CS2697, "CERT", CY2:CY2697,"No Name High School")
I want to know, from my report, how many "cert" employees work at "No Name High
May 17 2022 08:43 AM - edited May 17 2022 08:47 AM
Per the documentation:
Important: Each additional range must have the same number of rows and columns as the criteria_range1 argument. The ranges do not have to be adjacent to each other.
So, the range provided to the first and third parameters must represent the same number of rows.
Try:
=COUNTIFS($CS$2:$CS$2697, "CERT", $CY$2:$CY$2697,"No Name High School")
May 18 2022 08:31 AM