LinkBack URL
About LinkBacksHow 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?
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
Bruce
The older I get, the better I used to be.
USA
sure
=COUNTIF(A:A,"x")
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Highlander" <Highlander@discussions.microsoft.com> wrote in message
news:B41EB742-0DA2-45BD-B384-582ADEB8A7AA@microsoft.com...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks