Countifs results in #VALUE! error

New Contributor

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

2 Replies

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")

 

Thank you.
I was actually able to solve this by using "define names" for the columns. I will try your suggestion as well to see if that works.