why does "=counta(d9:d44)" return "37"

I

imfletcher

Just wondering why when I use the COUNTA function in my spreadsheet it
returns a value that is one more than actual answer. This new math is driving
me crazy.
 
D

Dave F

counta counts text and numbers. Maybe you're looking for count? Or maybe
one of your cells which you think is not formatted as text is formatted as
text.
 
R

RagDyer

Are you sure that you formula is *exactly*:

=COUNTA(D9:D44)
?
Both of these will return 37:
=COUNTA(D9:D44,)
=COUNTA(,D9:D44)
 
Top