In the attached WB, RESULTS 1 D30 sums the last 3 weeks. However, I don't want to include the present week. I would like the 3 prev weeks. Below is that formula... Is there a way to amend this to calculate the prev 3 weeks, not including the present week?
Please Login or Register to view this content.
Last edited by cableghost; 11-12-2021 at 01:37 AM.
In D30 Cell
Formula:
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks for the formula.
Actually, this formula provides the same result. I updated the WB to include more data. D30 in RESULTS 1 should read 8 (rounded up from 7.75).
Last edited by cableghost; 11-12-2021 at 01:36 AM.
Try
=SUMIFS(Table2[POINTS],Table2[WEEK],">="&MAX(Table2[WEEK])-3,Table2[WEEK],"<="&MAX(Table2[WEEK])-1)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Try at D30
=SUMIFS(Table2[POINTS],Table2[WEEK],">="&MAX(Table2[WEEK])-3,Table2[WEEK],"<"&MAX(Table2[WEEK]))
@JohnTopley, this seems to work, thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks