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