N nip Dec 10, 2008 #1 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
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 Dec 10, 2008 #2 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*")
N nip Dec 10, 2008 #3 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.
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 Dec 10, 2008 #4 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
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
