Counting Text as a Number

J

Jan from ROF

I am trying to "Count" a column which has text in it. I'm at a complete
loss. The count and sum formulas ignore text. Can anyone help?
 
G

Gary''s Student

Remember that COUNTA will count cells that APPEAR to be empty if they contain
a formula that is returning an empty string or a cell that contains spaces.


COUNTA will also count cells with numbers in them.
 
J

Jan from ROF

Fixed...works....thanks!

Gary''s Student said:
Remember that COUNTA will count cells that APPEAR to be empty if they contain
a formula that is returning an empty string or a cell that contains spaces.


COUNTA will also count cells with numbers in them.
Click to expand...
 
Top