Forum Discussion
Solved
Sum of values within overlapping date ranges
Hello, I hope you're well. I was wondering if someone could help me with a formula to sum values within a date rage. Some of the date ranges overlap. Based on the data I have in columns A-D I would...
SUMIFS() shall work if change first condition on $A$3:$A$6,"<="&$F5
=SUMIFS($D$3:$D$6,$A$3:$A$6,"<="&F3,$B$3:$B$6,">="&F3)
Your formula calculates the same result if you switch "<" and ">".
Thank you very much for your help. Switched them as suggested and it worked 🙂