=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