and at the end of the column have the total number of letter "P" found.
2006-10-10 17:40:20 · 4 answers · asked by Anonymous in Computers & Internet ➔ Software
You can use the COUNTIF function. Just include the range and the criteria. Example: =COUNTIF(A1:A100, "P")
2006-10-10 17:45:55 · answer #1 · answered by noobiepower 2 · 0⤊ 0⤋
I would break this problem into parts. First I would check one cell at a time for the letter P and place a 1 or 0 in the adjacent cell. Then just total the columns for the 1s and 0s.
2006-10-10 17:43:24 · answer #2 · answered by rscanner 6 · 0⤊ 0⤋
If you want to count all the "P"s you could use the =countif() function. If you want to find and replace all the "P"s you could use CTRL-H. You can also use =vlookup() to find a P in the column and return an associated value from the column next to it.
Finally, you could use the PivotTable wizard to sum the "P"s or sum data related to the "P"s...
2006-10-10 17:45:31 · answer #3 · answered by ? 3 · 0⤊ 0⤋
Assume you have your list in column B, then paste this in D1
=COUNTIF( B:B, "*P*")
now this cell (D1) will show you how many cells that have letter "P"
If you want more, you can add new column (Column C) and paste this function in C1
=len( B1)-len( SUBSTITUTE( B1,"p",""))
then fill in the cells below, now make a sum for this C column and you will get every "p" found in all cells
Notice that this is a case sensitive function, if you want a non case sensitive, use this
=len( B1)-len( SUBSTITUTE( B1,"p","")) + len( b1)-len( SUBSTITUTE( B1,"P",""))
mail me any further questions
Read my profile, I am the XLMan
2006-10-11 01:01:40 · answer #4 · answered by Anonymous · 1⤊ 0⤋