Hi.
I have several columns of data and I would like to take the average of each of these columns separately.
First, I do AVERAGE() on the first column and get the correct number
Next, I drag the value in that cell across the remaining columns of which I want to take the average.
Excel does this, but keeps the original value for the first cell in each instance! I check the formulas and they are correct - when I delete and re-enter the last parenthesis ")" the formula refreshes to its correct value.
This is bothering me a ton, as I wonder what other calculations my Excel is messing up.
Bookmarks