Actually, this is probably what you wanted.

=SUMPRODUCT(--(LEN(H2:H50)-LEN(SUBSTITUTE(H2:H50,"x",""))))

--
Don Guillett
SalesAid Software

"Calculation of Text" <Calculation of wrote
in message ...
I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc.
Can these be added up like #'s in the column?