View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default 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)