COUNT command

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks for the suggestion on "COUNT". My new problem is that some of the cells contain text AND numbers and I still want it to count. The syntax you gave me seems to count only the cells with numbers. ie:

Vehicle number

102
104
256
A01
A11

total = 3 (should be 5)

Pat
 
You received another answer by Frank Kabel in your original thread

=COUNTA(Range)

--

Regards,

Peo Sjoblom

Pat said:
Thanks for the suggestion on "COUNT". My new problem is that some of the
Click to expand...
cells contain text AND numbers and I still want it to count. The syntax you
gave me seems to count only the cells with numbers. ie:
 
Back
Top