I don't know why I can't get this right, I googled and tried a bunch of suggestions that matched my problem but I'm going wrong somewhere.
Simply put I want to fill down in a seperate column some averages skipping every 7 cells. It has labels of 4/7, 4/14, 4/21, down each row and next to it I would like to fill in weekly averages like =average(A1:A7), =average(A8:A14), =average(A15:A21)
Naturally fill down will give me =average(A1:A7), =avg(A2:A8), A3:A9, etc which is no good to me.
I thought OFFSET would do it for me but I must be doing something wrong.
heres a snippet of my data (ignore the % column)
HTML Code:
I know I have to be missing something real simple here---in fact I think I used to know how to do this but after messing around with pivot tables and failing at offset I figured I better just get help. Thanks to any assistance anyone can offer.
Bookmarks