Forum Discussion

SebaKMTAlex's avatar
SebaKMTAlex
Copper Contributor
Apr 25, 2025
Solved

Count drop down list occurrences across multiple sheets

I have a workbook with multiple sheets from January - December, I've been trying to have my formula count every instance of a drop down selection for each sheet, but i keep getting the #NAME? error. ...
excel
Formulas and Functions
  • m_tarler's avatar
    m_tarler
    Apr 25, 2025

    not sure why you are using INDIRECT but I'm pretty sure COUNTIF won't work on a cross sheet reference regardless.  Maybe try:

    =SUMPRODUCT(--(HSTACK('January:December'!C:C)="Repair"))

m_tarler's avatar
m_tarler
Bronze Contributor
Apr 25, 2025

not sure why you are using INDIRECT but I'm pretty sure COUNTIF won't work on a cross sheet reference regardless.  Maybe try:

=SUMPRODUCT(--(HSTACK('January:December'!C:C)="Repair"))

SebaKMTAlex's avatar
SebaKMTAlex
Copper Contributor
Apr 25, 2025

Thank you this did the trick, I've been trying to teach myself and that's the formula i found. 

Resources