finding error in range

D

Dan

Is there a way via formula (not code - as I want it to refresh on every calc)
to find if there is an error in a range.
I tried an array formula - but woking only for the first cell (B5)
{=ISError(B5:G5)}
Many thanks,
Dan
 
G

Gary''s Student

=SUMPRODUCT(--(ISERROR(B5:G5))) > 0

will return true if there are any errors.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF function says too many nested 1
Array to Multiple Arrays 3
Naming non-contigent cells with vba 5
Address of Selection Prior to Clicking on a Cell 1
Copy addition formula of non-consecutive horizontal cells 2
Refresh Queries in All Worksheet 2
Pasting formula in every nth row 3
Check cells in row for last cell with data to use as multiplier? 0

Top