Forum Discussion
Solved
Need help using =sumifs()
Hello, I'm trying to figure out how to return sum of specified range, with 2 criteria, the category is "x" and also falls into a specified month(x). I'm currently using the following formula: =SUMIF...
Hi there.
Untested.
=SUMIFS($C:$C,$D:$D,">=01.01.2018",$D:$D,"<=31.01.2018",$A:$A,"Services")
Hi there.
Untested.
=SUMIFS($C:$C,$D:$D,">=01.01.2018",$D:$D,"<=31.01.2018",$A:$A,"Services")
Thank you, your formula didn't work exactly but with a few minor tweaks I got it to work. I must of gotten tunnel vision on this so I appreciate the help!
Here is what worked
=SUMIFS($C:$C,$D:$D,">=01/01/2018",$D:$D,"<=01/31/2018",$A:$A,"Services")
I can't thank you enough!
Here is what worked
=SUMIFS($C:$C,$D:$D,">=01/01/2018",$D:$D,"<=01/31/2018",$A:$A,"Services")
I can't thank you enough!