0

I have a column that totals earning, B4:B, which sums up all values, however, I just want it to total values from last (most recent) Monday to Now, until it's Monday again, start over, the date column is A4:A.

I've tried;

=SUMIF(A4:A,">="&(DATEDIF(ARRAYFORMULA(A4:A),TODAY(),"D"),B4:C)")))")

2
  • Please define last Monday more clearly. Suppose today is Wednesday. Does last Monday means Monday of this week? Or Monday of last week? Or the latest date in column A that's a Monday, regardless of how far back it is?
    – daniel
    Feb 18, 2016 at 0:50
  • If today is Wednesday, then last 2 days on. If today is Monday, today on. If today is Sunday, last possible Monday on. (Monday may not always be there, if that's the case it would be the last tuesday) Feb 18, 2016 at 5:22

1 Answer 1

2
=sumif(A4:A,">" & (today()-weekday(today(),3)),B4:B)

where weekday(today(),3) gives you the weekday where Monday = 0 and Sunday = 6

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.