Each week a total is calculated for the week just passed. Each 8th row is reserved for subtotals.
What I need is to have the 8th row make a subtotal each time. What i need should result in the following logic:
'=IF(MOD(ROW()-1,8),C9,SUM(D2:D8))
'=IF(MOD(ROW()-1,8),C10,SUM(#REF!))
How do i get the sum range to look at the 7 preceding rows each time?
Last edited by Baabaa; 10-23-2021 at 10:10 PM. Reason: Upload sample file
There are instructions at the top of the page on how to post a sample sheet
Something like this?
F11=IF(MOD(ROWS(F$11:F12),8),,SUM(OFFSET(B12,,,-8)))
Data in that example in B11 and down.
Thank you. I used part of the only other response. Can you assist me further?
Try this: D2==IF(MOD(ROWS(D$2:D2),8),C2,SUM(OFFSET(D1,,,-7)))
Edited: To correct wrong interpretation.
Another way.
In E9 and filled down.and then fill up ↑.Formula:
Please Login or Register to view this content.
Last edited by FlameRetired; 10-21-2021 at 11:29 AM. Reason: correct bad formula
Dave
Originally Posted by RaulSerg
I didn't understand your response the first time but this solution actually solves my problem perfectly. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks