| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
=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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
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 |
|
#8
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
| Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
| Excel: Is there a way to calculate the date as week of month? | Excel Discussion (Misc queries) | |||
| Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions | |||
Linear Mode
