You must be having formulas in the range which return blank entries...Try one
of these formulas

=COUNTIF(AL10:AL8002,"?*")+COUNT(AL10:AL8002)
=SUMPRODUCT(--(TRIM(AL10:AL8002)<""))

If this post helps click Yes
---------------
Jacob Skaria


"Gotroots" wrote:


The following formula returns a total of 53 when in fact it should be 39

=COUNTA(AL10:AL8002)+'other additions'!AK5

puzzled