Count Errors
Enter the below formula into a cell as an array formula (Push Ctrl, Shift and Enter simultaneously)
{=SUM(IF(ISERROR(A1:A10),1))}
or
=SUMPRODUCT(--ISERROR(A1:A10))
or
=SUMPRODUCT(ISERROR(A1:A10)+0)
or
=SUMPRODUCT(ISERROR(A1:A10)*1)
© Copyright
andrewsexceltips.net
All Rights Reserved.