Solution to count occurrences of cells that contain "0" from a data download

[JenMcG]

Hello,

I am having issues with the following formula:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(AF31:AF5010,ROW(AF31:AF5010)-MIN(ROW(AF31:AF5010)),,1))*(AF31:AF5010="0"))

The data contained in this spreadsheet is downloaded from another database (& pasted into this spreadsheet) and it returns a "0" or "$-" when the Original Upload Amount has not been submitted. I would like the ability to count the occurrences of these "0" when a filter is applied. I repurposed an old formula from a different spreadsheet that performs the same function for counting the occurrences of the word "YES" and substituted the "YES" for "0" which did not work. I also tried "$-".

Does anyone have any other recommendation to get this count working?

Thanks,

 

[Fluff]

Try removing the quotes from the "0" so it's just 0

 

[JenMcG]

Try removing the quotes from the "0" so it's just 0

Perfect! Thank you

 

[Fluff]

You're welcome & thanks for the feedback.