Adding a column in Excel 2007

  • Thread starter Thread starter nip
  • Start date Start date
N

nip

Have a column with letters in it. Want to sum up how many of one
letter I have in the column. What is a formula to do this please
 
To count the number of cells that equal X
=countif(a:a,"X")

To count the number of cells that have at least one X in them:
=countif(a:a,"*X*")
 
To count the number of cells that equal X
=countif(a:a,"X")

To count the number of cells that have at least one X in them:
=countif(a:a,"*X*")
Click to expand...

Thank you - it works if I put the formula in a column other than the
one I am counting. Is there a way to have it in the same column.
 
Adjust the range to avoid the cell with the formula:

=countif(a1:a99,"x")
if a100 contains the formula
or
=countif(a2:a99,"x")
if a1 contains the formula
 

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

How to set cell value to emptry if three other columns are empty too 1
Pattern Matching in Excel 2007 1
counting formula 3
Help needed 0
How to type each letter of the alphabet automatically in a specific color in Word? 0
Help with ISNUMBER formula 2
Limit a field to 3 digits 1 capital letter 1nd 2 numbers 6
Custom Filter 5

Back
Top