Forum Discussion
Solved
SUMIFS FUNCTION WITH MULTIPLE CRITERIA USING START DATE AND END DATE
Hello Everyone... I've been scouring the internet for a solution to this issue, and it's now my third day at the office, which is really eating into my time. I could use your help! I'll attach a s...
In B2
=SUMIFS( Sheet1!$B$2:$B$11, Sheet1!$A$2:$A$11, $A2, Sheet1!$C$2:$C$11, "<=" & B$1, Sheet1!$D$2:$D$11, ">=" & B$1 )and drag it to the down and right.
In B2
=SUMIFS(
Sheet1!$B$2:$B$11,
Sheet1!$A$2:$A$11, $A2,
Sheet1!$C$2:$C$11, "<=" & B$1,
Sheet1!$D$2:$D$11, ">=" & B$1
)and drag it to the down and right.
SergeiBaklan 🤗it worked...! Thanks and Lot, you saved me a lot of time on all that manual calculation. 😥
arunknarayan93 , you are welcome, glad to help