Summing Columns
 

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?

sure

=COUNTIF(A:A,"x")

--

HTH

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


"Highlander" wrote in message
...
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?

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

=COUNTIF(A1:A10,"x")

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=390986