Count Numbers in Range
=SUMPRODUCT(--ISNUMBER(A1:A10))
=SUMPRODUCT(ISNUMBER(A1:A10)+0)
=SUMPRODUCT(ISNUMBER(A1:A10)*1))
or
{=SUM(IF(ISNUMBER(A1:A10),1))}
Push Ctrl, Shift and Enter to make this an array formula
or
=COUNT(A1:A10)
© Copyright
andrewsexceltips.net
All Rights Reserved.