February 16, 2018
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.
April 21, 2015