Strange thing happens...
Try one of these formulas
=AVERAGE($A$1:$A$6)
or
=AVERAGE(INDIRECT("A1:A6"))
or
=AVERAGE(OFFSET($A$1,,,6,))
"TomCat" wrote:
I created a spreadsheet that tracks manhours 7 days a week with the week
starting on Saturday. Our main workdays are Sat thru Thurs and we have a
skeleton crew on Fridays. This is a very large project so I track the average
manhours of the first 6 days ONLY. I don't use Fridays. So, there are 7
cells, the first 6 of which I calc the average in the 8th cell like this:
=AVERAGE(Cell1:Cell6)
Now here's the strange thing: whenever I enter a value in the 7th cell, my
formula changes automatically and calcs the average of ALL SEVEN! I don't
want the average of all seven, I only want the average of the first 6 cells!
I have to change the formula back every time I enter a value in the 7th cell.
What's happening here? This is a very large project and I'm spending a lot
of wasted time changing all my formulas back to average the first 6 cells
only!
Thanks.........TomCat
|