View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier David Billigmeier is offline
external usenet poster
 
Posts: 176
Default Count data in cells

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