Summing Columns

H

Highlander

How do I add non-numbered columns in excel? I want to enter an "x" instead
of a "1" and want a total of "x"'s. Can I do this?
 
B

Bob Phillips

sure

=COUNTIF(A:A,"x")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
S

swatsp0p

Use COUNTIF to count the number of 'x's in your range, e.g.:

=COUNTIF(A1:A10,"x")

HT
 
Top