View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DD DD is offline
external usenet poster
 
Posts: 68
Default Count data in cells

Yes, thank you so much. It worked.

"David Billigmeier" wrote:

So you just want a count of the cells with information in them?

=COUNTA(A1:A3)

--
Regards,
Dave


"dd" wrote:

If I enter the following into individual cells what formula do I use so it
recognizes it when I total the column?

A1 v65.49
A2 v65.49
A3 v45.89
Total 3