Count data in cells
 

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

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

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

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