Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Strange thing happens...
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One Last Thing | Excel Discussion (Misc queries) | |||
Strange Thing Happening | Excel Worksheet Functions | |||
Is there such a thing... | Excel Discussion (Misc queries) | |||
Strange thing happened with TOC | Excel Discussion (Misc queries) | |||
one more thing | Excel Worksheet Functions |