calculating the mean

B

Barb

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
 
P

Peo Sjoblom

=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)
 
J

joeu2004

Barb said:
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top