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