I have created what I call "Verifier" formulas in a large workbook to ensure
that my data, as well as my formulas are all acting in the way I intended, I
also use them to double check data entry.

I use "IF" formulas for all of my verifier cells. [=IF(A1=A2, "OK", "NOT OK")]
After the logical test the cell returns either ok, or not ok, using this
function with conditional formulas I can easily find errors in my
spreadsheets.

The problem that I'm running into is that I would like to have a master cell
at the top of each of my spreadsheets that can tell me if any of my verifier
cells are returning a certain text value (NOT OK).

I've tried using EXACT, LOOKUP, and some other formulas but keep running
into errors.

Does anyone know of a way to accomplish this?

(The cells are spread across the spread sheets and are in no particular
order.)