View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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.