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 2004 - 2007,
andrewsexceltips.com
. All Rights Reserved.