Count data in cells

[Guest]

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

 

[Guest]

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

=COUNTA(A1:A3)

 

[Guest]

Yes, thank you so much. It worked.

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

=COUNTA(A1:A3)

 

[PCLIVE]

=COUNTA(A:A)

HTH,
Paul