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 |
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 |
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) |
All times are GMT +1. The time now is 05:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com