Strange Sum/Average Behavior

  • Thread starter Thread starter Josh W.
  • Start date Start date
J

Josh W.

So, I've got this equation to SUM two averages. Here it is:

=SUM(B7:B8)/COUNT(B7:B8)+SUM(B9:B10)/COUNT(B9:B10)

Simple enough, right?

WELL, I just discovered that I needed to add extra rows. When I did so,
the equation turned to this, naturally:

=SUM(B7:B9)/COUNT(B7:B9)+SUM(B10:B12)/COUNT(B10:B12)

However...! When I began to add values the equation turned into this
on its own(!):

=SUM(B7:B12)/COUNT(B7:B12)+SUM(B10:B12)/COUNT(B10:B12)

As I added the values down the line, after the third value entered, the
function expanded to SUM/COUNT the whole of the 6 rows, instead of
the first 3 rows only. It looks like some sort of macro or automatic
function, but I don't know how to turn it off. It's throwing off my
figures.

Thank for any help!
 
Tools>options>edit>extend list formats and formulas

might be the reason, if so uncheck it
 
That did it! Once again, you've proven to be the STUD of the universe.
(That's a good thing.)

Blessings, Josh
 
Back
Top