# Posts by nire000

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

Many thanks
Erin

## Files

Hi I need to sum 5 rows at a time, i.e. a1:a5 then B6:B10 etc - which I can do BUT how do I get this information to go in cell C2, C3, C4 etc

So cell C2 will contain the sum of B2:B6
C3 will contain sum of B7:B11
C4 will contain sum of B12:B16 and so on etc

I know I can do sum (B2:B6) and then highlight cells C2:C6 and drag down
But that gets me the answer every 5th line, and I need it on every line

I know i could also manually write this in, but i need to do this for hundreds of times so this isnt possible

Any help you could provide in a formula would be greatly appreciated

Kind regards
Erin