Adding a column in Excel 2007

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
 
D

Dave Peterson

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*")
 
N

nip

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.
 
D

Dave Peterson

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
 
Top