Forum Discussion
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. Can you assist in finding where I made the mistake in my formula? Thank you.
=SUMPRODUCT(COUNTIF(INDIRECT("'"&January:December&"'(!C:C"),"Repair"))
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"))
2 Replies
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"))
Thank you this did the trick, I've been trying to teach myself and that's the formula i found.
