Hei
I have encountered one annoying problem..
I have weeks in one column A and days in column B. Lets say the numbers in column B are apples, different numbers for each of the seven days in each week. In the formula i want to have the average for each week, and copy this all the way down.
I write =Average(B5:B11), and the next I want to be =average (B12:18), but if i copy the formula I will get (B6:B12), and next (B7:B13). I want the average for 7 and 7 days all the way down, it annoys me that I can’t figure this out..Please tell it’s an easy way around this.
This depends on the way you select and copy and paste.
In your example you want to have the average B5:B11 in cell C11 I think?
So in cell C11 you make the formule you descripe.
When you copy that formula to cell C18 it'll work fine!
Frans
