How do I autosum text?

  • Thread starter Thread starter Guest
  • Start date Start date
=SUMIF(B:B,"X",A:A)

Assuming that column B contains all the Xs and column A contains the values
you want to sum.

Note instead of defining columns you can also define ranges.
 
Perhaps you mean "count" rather than autosum?

=COUNTIF(A1:A12,"x")


Gord Dibben Excel MVP
 
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

Autosum and formulas that result in text 4
Totaling text cells 2
autosum refusal to sum highlighted range 4
How do I make AutoSum really Sum, not Subtotal 5
AutoSum (sigma) symbol disappeared 1
Combo boxes and AutoSum 1
How to SUM in a protected spreadsheet 3
Why do I get #### when I Autosum in Excel? 2

Back
Top