ExcelBanter - finding error in range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - finding error in range (https://www.excelbanter.com/excel-programming/406781-finding-error-range.html)

dan

finding error in range

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

Gary''s Student

finding error in range

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

will return true if there are any errors.
--
Gary''s Student - gsnu200770

All times are GMT +1. The time now is 08:56 AM.