View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Barb is offline
external usenet poster
 
Posts: 70
Default 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