Posts by nire000

  • Sum blocks of cells comprised of X rows

    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?
    Many thanks
    Erin

  • Sum blocks of cells comprised of X rows

    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