Test Range of Cells for a Value 0

[Mojave]

Greetings.

I need to know if any of my formulas in a certain range have a value of 0 (zero). Range has multiple rows and columns.

I don't need conditional formatting on the cells themselves, I need this to appear in a separate area of the sheet, like a dashboard.

For instance:

Cell a1: new Formula with result of "Zero Exists" or "No Zeroes"

Range that might have zeroes: W20:AH40


I have used the search function but haven't seen anything that works for me.

Thanks for looking!!

[Pete_UK]

Try this:

=IF(COUNTIF(W20:AH40,0)>0,"Zero exists","No Zeroes")

Hope this helps.

Pete

[Mojave]

Very excellent answer! Perfect!

Thank you so much, reputation added.

[Pete_UK]

Thanks for feeding back - glad to be of help.

Pete