hey ya'll how do i auto sum a cell using the letter x instaed of .

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

Guest

hey ya'll how do i auto sum a colum using the letter x instead of using a
number
 
To count number of "x"es

=COUNTIF(A1:A100,"x")

Gord Dibben Excel MVP
 
Gord answered but I couldn't resist asking what the sum of x and x is?
Sinister Rod Serling music here.
 
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

Excel Sum numbers in cells that also contain text 34
The next Grand Theft Auto title has been officially announced 0
Copy Sheet #'s, but leave cell reference 3
Auto Sum issue 2
sum totals in excel 4
How to type each letter of the alphabet automatically in a specific color in Word? 0
Using sum on a column I am getting ### instead of a total 4
how do I sum fields down through a fixed field value. 1

Back
Top