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

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.

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

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.
--
Brevity is the soul of wit.


"imfletcher" wrote:

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.

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

Are you sure that you formula is *exactly*:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"imfletcher" wrote in message
...
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.