Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating the mean
I apologize for this stupid question, but I'm trying to calculate the mean of
the following cells and format it into a percentage E3 189 F3 93% G3 198 H3 93% I3 211 J3 92% K3 196 L3 93% M3 224 93332% - Here's my formula: =(B3*C3)+(D3*E3)+(F3*G3)+(H3*I3)+(J3*K3)+(L3*M3)/(C3+E3+G3+I3+K3+M3) Please help! Thanks -- bd |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating the mean
=AVERAGE(Range)
your formula looks more like you are trying to get some weighted average? If you add some parenthesis =(B3*C3)+(D3*E3)+(F3*G3)+(H3*I3)+(J3*K3)+(L3*M3)/(C3+E3+G3+I3+K3+M3) if you change the setup a bit and you put all the percentage in one range and the other values in another range with both ranges the same size you could use =SUMPRODUCT(C3:H3,C4:H4)/SUM(C4:H4) percentage in C3:H3 and the other values in C4:H4 -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email) "Barb" wrote in message ... I apologize for this stupid question, but I'm trying to calculate the mean of the following cells and format it into a percentage E3 189 F3 93% G3 198 H3 93% I3 211 J3 92% K3 196 L3 93% M3 224 93332% - Here's my formula: =(B3*C3)+(D3*E3)+(F3*G3)+(H3*I3)+(J3*K3)+(L3*M3)/(C3+E3+G3+I3+K3+M3) Please help! Thanks -- bd |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating the mean
Barb wrote:
I apologize for this stupid question There are no stupid questions :-). but I'm trying to calculate the mean of the following cells and format it into a percentage [....] Here's my formula: =(B3*C3)+(D3*E3)+(F3*G3)+(H3*I3)+(J3*K3)+(L3*M3)/(C3+E3+G3+I3+K3+M3) Not the best way to arrange the data. But to correct your formula, you only need to insert some parentheses around the entire numerator, just as you have them around the denominator, to wit: =( (B3*C3)+(D3*E3)+(F3*G3)+(H3*I3)+(J3*K3)+(L3*M3) ) / (C3+E3+G3+I3+K3+M3) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculating time | Excel Discussion (Misc queries) | |||
Calculating Cells n% displayed in a cell? | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) |