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
=SUMPRODUCT((F3>=$A$3:$A$6)*(F3<=$B$3:$B$6)*$D$3:$D$6)
Is this the formula you are looking for?
- This formula also worked perfectly! Thank you very much 🙂
