Forum Discussion
arunknarayan93
Sep 06, 2024Copper Contributor
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...
- Sep 07, 2024
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.
JKPieterse
Sep 06, 2024Silver Contributor
arunknarayan93 Is this an Excel question or a Google sheets question? Anyway, we do not have access to that file you linked to.
- arunknarayan93Sep 07, 2024Copper Contributor
JKPieterse I'm using Microsoft Excel 2021 Version 2410
I had changed the privacy setting of the link I have shared