Summing Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Use COUNTIF to count the number of 'x's in your range, e.g.:

=COUNTIF(A1:A10,"x")

HT
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF "value if false" not working 2
How to SUM on a condition? 2
Formula for adding sums 3
Converting specific text to numbers then sum 8
Offset 2
How can I use a UDF in a SUM Function? 2
Array function - I think! 8
Set non-continuous PrintArea via Function / Name 0

Back
Top