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() shall work if change first condition on $A$3:$A$6,"<="&$F5
Thank you very much for your help. This is great!! It worked 🙂