Forum Discussion

pmaddams's avatar
pmaddams
Copper Contributor
May 17, 2022

Countifs results in #VALUE! error

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

excel
Formulas and Functions

2 Replies

  • flexyourdata's avatar
    flexyourdata
    Iron Contributor
    May 17, 2022

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

     

    • pmaddams's avatar
      pmaddams
      Copper Contributor
      May 18, 2022
      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.

Resources