Re: Sum 5 rows - question
forum.ozgrid.com/index.php?attachment/39070/Thank you that worked perfectly for that example i sent.
What would i modify if i wanted to have my answers on another tab/sheet and also starting on a different row number.
i.e. i have attached a worksheet (example 2) which is very similar to the actual i am trying to work from.
Production! is the tab with the information, i want to start gathering the data from R5:R10 then R11:R15 etc
The tab i want the information to collect on is Bottles! and i want to start collecting the data on L5, L6, L7 etc
So Bottles! L5 has the sum of Production!R5:R10 and Bottles! L6 has the sum of Production! R11:R15 etc
I tried but couldnt get it to completely work
I managed to start pulling data from the other sheet by adding this into your equation =SUM(OFFSET(Production!$R$1,ROW()*5-9,0,5))
But i cant get the right cells to add up correctly
i.e. L5 should = 3008 / L6 = 4008 / L7 = 0 / L8 = 489 etc
Can you please help at all?