I have daily production listed on one sheet. On a separate tab, I want to calculate the average for the week (Jan 1-7, Jan 8-14 etc..), but when I drag my average formula down, it skips to the next cell, not the next set of data.
ie: first cell calculates Jan 1-7, second cell calculates Jan 2-8 etc...
I've tried playing with an offset formula, but can't quite make it work..
Any help would be appreciated!
In B2
=AVERAGE(INDEX(Production!B:B,(ROW(A1)-1)*7+2):INDEX(Production!B:B,(ROW(A1)-1)*7+8))
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Hmmm...that formula came back "TRUE". No average.
Hi rtwells
To simplify things, I have changed your dates in Column A to proper dates on the Production sheet. On the Averages sheet added anothe column and put in proper dates. See the attached.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks