I want to sum every 7 rows in a worksheet and put the sum in different column & rows

excel worksheet-function
pixeldev picture pixeldev · Sep 9, 2010 · Viewed 48k times · Source

I have never really used Excel before but this seems like it should be possible.

I have an ongoing document where I will be adding values every day, but what I want it to do for every 7 rows I want it to sum those values and add the sum of the 7 rows to a different column/row, e.g.,

Row B7:B14 Sum in D12
Row B15:B22 Sum in D13

And then when I start adding data into B23 I want it to add the sum to D14.

Answer

Dick Kusleika picture Dick Kusleika · Sep 9, 2010

In D12, put

=SUM(OFFSET($B$7,(ROW()-12)*8,0,8,1))

and fill down column D as far as you want. Note that B7:B14 is really 8 rows, not 7. If you really want 7 rows (B7:B13), then change the two 8's to 7's in the formula.

Related questions

IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
Get values from other sheet using VBA

I want to get values from other sheets. I have some values in Excel (sheet2) for example: A B C D - - - - 1 | 2 5 9 12 2 | 5 8 4 5 3 | 3 1 2 6 I sum each column in row 4. I'm working with these values in sheet2 but I …

Read More
Excel formula to get cell color

I would like to know if we can find out the Color of the CELL with the help of any inline formula (without using any macros) I'm using Home User Office package 2010.

Read More