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)")))")

Improve this question
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)
    – Spongebob Squarepants
    Feb 18, 2016 at 5:22

1 Answer 1

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

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

Improve this answer
0

Your Answer

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

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