Question posted 2010 · +5 upvotes
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.
Accepted answer +12 upvotes
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.
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
.