View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Count data in cells

=COUNTA(A:A)

HTH,
Paul

"dd" wrote in message
...
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