can excel calculate a letter

K

kristi _ 71

i need to make a spreadsheet , with it able to calculate the letter p in a
cell and total at the bottom of the sheet
 
M

Myrna Larson

What do you mean by "calculate the letter p"? Insert that character into a
cell? Make it part of the formula result? Just display it without making it a
part of the data?
 
K

kristi _ 71

well ,,, i need it to count all the (P') ... i will put a p in each cell ...
i need it to calculate it at the bottom... i messed the formula up somehow
and i dont know how to fix it right
 
K

kristi _ 71

HOW DO I CHANGE THER REFERENCE .. I M NOT SURE WHAT EXACT STEPS I NED TO TAKE
,,, OR HOW TO IMPUT THE FORMULAS
 
G

GY

hi there,
can u tell me how to link this result to another worksheet?
say on another sheet, i would need to calculate the Ps, but would also like
to accumulate the Ps from the previous sheet?

thanks very much for ur help!
 
B

Biff

Hi!

Assume you want to count "P's" on both Sheet1 and Sheet2.

The formula is in Sheet1:

=COUNTIF(Sheet2!A1:A10,"P")+COUNTIF(A1:A10,"P")

OR:

=SUMPRODUCT((Sheet2!A1:A10="P")+(A1:A10="P"))

Biff
 
Top