|
can excel calculate a letter
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 |
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? On Tue, 22 Feb 2005 17:59:02 -0800, "kristi _ 71" <kristi _ 71 @discussions.microsoft.com wrote: 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 |
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 "Myrna Larson" wrote: 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? On Tue, 22 Feb 2005 17:59:02 -0800, "kristi _ 71" <kristi _ 71 @discussions.microsoft.com wrote: 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 |
=COUNTIF(B2:B58,"p") Change the reference to the range you want to count. On Tue, 22 Feb 2005 19:19:04 -0800, "kristi _ 71" wrote: 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 "Myrna Larson" wrote: 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? On Tue, 22 Feb 2005 17:59:02 -0800, "kristi _ 71" <kristi _ 71 @discussions.microsoft.com wrote: 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 |
HOW DO I CHANGE THER REFERENCE .. I M NOT SURE WHAT EXACT STEPS I NED TO TAKE
,,, OR HOW TO IMPUT THE FORMULAS "Myrna Larson" wrote: =COUNTIF(B2:B58,"p") Change the reference to the range you want to count. On Tue, 22 Feb 2005 19:19:04 -0800, "kristi _ 71" wrote: 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 "Myrna Larson" wrote: 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? On Tue, 22 Feb 2005 17:59:02 -0800, "kristi _ 71" <kristi _ 71 @discussions.microsoft.com wrote: 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 |
Rewrite the formula so instead of B2:B58, it refers to the cells you want.
On Tue, 22 Feb 2005 20:25:02 -0800, "kristi _ 71" wrote: HOW DO I CHANGE THER REFERENCE .. I M NOT SURE WHAT EXACT STEPS I NED TO TAKE ,,, OR HOW TO IMPUT THE FORMULAS "Myrna Larson" wrote: =COUNTIF(B2:B58,"p") Change the reference to the range you want to count. On Tue, 22 Feb 2005 19:19:04 -0800, "kristi _ 71" wrote: 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 "Myrna Larson" wrote: 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? On Tue, 22 Feb 2005 17:59:02 -0800, "kristi _ 71" <kristi _ 71 @discussions.microsoft.com wrote: 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 |
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! "Myrna Larson" wrote: Rewrite the formula so instead of B2:B58, it refers to the cells you want. On Tue, 22 Feb 2005 20:25:02 -0800, "kristi _ 71" wrote: HOW DO I CHANGE THER REFERENCE .. I M NOT SURE WHAT EXACT STEPS I NED TO TAKE ,,, OR HOW TO IMPUT THE FORMULAS "Myrna Larson" wrote: =COUNTIF(B2:B58,"p") Change the reference to the range you want to count. On Tue, 22 Feb 2005 19:19:04 -0800, "kristi _ 71" wrote: 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 "Myrna Larson" wrote: 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? On Tue, 22 Feb 2005 17:59:02 -0800, "kristi _ 71" <kristi _ 71 @discussions.microsoft.com wrote: 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 |
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 -----Original Message----- 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! "Myrna Larson" wrote: Rewrite the formula so instead of B2:B58, it refers to the cells you want. On Tue, 22 Feb 2005 20:25:02 -0800, "kristi _ 71" wrote: HOW DO I CHANGE THER REFERENCE .. I M NOT SURE WHAT EXACT STEPS I NED TO TAKE ,,, OR HOW TO IMPUT THE FORMULAS "Myrna Larson" wrote: =COUNTIF(B2:B58,"p") Change the reference to the range you want to count. On Tue, 22 Feb 2005 19:19:04 -0800, "kristi _ 71" wrote: 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 "Myrna Larson" wrote: 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? On Tue, 22 Feb 2005 17:59:02 -0800, "kristi _ 71" <kristi _ 71 @discussions.microsoft.com wrote: 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 . |
| All times are GMT +1. The time now is 02:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com