software

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?

try
=countif(a:a,quot;xquot;)

--
Don Guillett
SalesAid Software

quot;Calculation of Textquot; lt;Calculation of gt; wrote
in message ...
gt;I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc.
gt; Can these be added up like #'s in the column?
You can use the length function to determine the number of characters in the
cell and then sum those values.

The formula below sums the length of the value in A2, to the lengths of the
value in A3 and so on.

=SUM(LEN(A2),LEN(A3),LEN(A4),LEN(A5))
--
Kevin Backmannquot;Calculation of Textquot; wrote:

gt; I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc.
gt; Can these be added up like #'s in the column?

Something like?

=countif(A1:A100,quot;=Xquot;)

=countif(A1:A100,quot;=XXquot;)*2

etc

HTHquot;Calculation of Textquot; wrote:

gt; I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc.
gt; Can these be added up like #'s in the column?



=COUNTIF(A:A,quot;xquot;) COUNTIF(A:A,quot;xxquot;)*2 COUNTIF(A:A, quot;xxxquot;)*3

Vaya con Dios,
Chuck, CABGx3
quot;Calculation of Textquot; wrote:

gt; I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc.
gt; Can these be added up like #'s in the column?

Actually, this is probably what you wanted.

=SUMPRODUCT(--(LEN(H2:H50)-LEN(SUBSTITUTE(H2:H50,quot;xquot;,quot;quot;))))

--
Don Guillett
SalesAid Software

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