1. ## Re: different results (2003)

You get different results because you are doing two entirely different things. Lets take a simple example using just four numbers: 1,1,2,4. Your first formula is the equivalent of:

(1+1)/(2+4) = 2/6 =1/3

Your second formula is the equivalent of (the AVERAGE function does nothing since the average of one number, the sum of all the fractions) is the same number):

(1/2)+(1/4) = (2/4)+(1/4) = 3/4

Which one is more correct depends on what you are trying to calculate, both are correct mathematical expressions. Also, your first formula is not calculating an average, it is calculating a ratio of two sums, and your second formula is calculating a sum of ratios since the AVERAGE is doing nothing.

2. ## Re: different results (2003)

Got it.
Sorry for posting my mind warp.
Thanks.

3. ## different results (2003)

Edited by HansV to break extremely long line

Why would you get different results when

(a) you divide 2 sums:
=SUM(N4:S18)/SUM(H4:M18)
=1.505E-03

([img]/forums/images/smilies/cool.gif[/img] divide each pair and then average
=1.609E-03
T4 through Y18 and Z5, attached spreadsheet

And © when you divide each pair and then average the results:
=AVERAGE(N4/H4+O4/I4+P4/J4+Q4/K4+R4/L4+S4/M4+N5/H5+O5/I5+P5/J5+Q5/K5+R5/L5+S5/M5+
N6/H6+O6/I6+P6/J6+Q6/K6+R6/L6+S6/M6+N7/H7+O7/I7+P7/J7+Q7/K7+R7/L7+S7/M7+N8/H8+O8/I8+
P8/J8+Q8/K8+R8/L8+S8/M8+N9/H9+O9/I9+P9/J9+Q9/K9+R9/L9+S9/M9+N10/H10+O10/I10+P10/J10+
Q10/K10+R10/L10+S10/M10+N11/H11+O11/I11+P11/J11+Q11/K11+R11/L11+S11/M11+N12/H12+
O12/I12+P12/J12+Q12/K12+R12/L12+S12/M12+N13/H13+O13/I13+P13/J13+Q13/K13+R13/L13+
S13/M13+N14/H14+O14/I14+P14/J14+Q14/K14+R14/L14+S14/M14+N15/H15+O15/I15+P15/J15+
Q15/K15+R15/L15+S15/M15+N16/H16+O16/I16+P16/J16+Q16/K16+R16/L16+S16/M16+N17/H17+
O17/I17+P17/J17+Q17/K17+R17/L17+S17/M17+N18/H18+O18/I18+P18/J18+Q18/K18+R18/L18+S18/M18)

=1.448E-01