SOLVED

Need help using =sumifs()

Copper Contributor

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:

=SUMIFS($C:$C,$D:$D,MONTH(1),$A:$A,"Services") but it only returns a value of zero.

If anyone can help or point me in the right direction I'd appreciate it. 

 

Here a snip of how I have my table arranged

 

ServicesCOX PHOENIX COMM SERV 800-234-3993 AZ03854910$72.993/19/2018
RestaurantsAH SO HAPPY VALLEY PHOENIX AZ$65.002/2/2018
Home ImprovementTHE HOME DEPOT #0424 PEORIA AZ$56.243/16/2018
SupermarketsSPROUTS FARMERS MARSPR AVONDALE AZ$55.223/5/2018
MerchandisePAYPAL *JUCARDILEMO 402-935-7733 CA$55.153/27/2018
SupermarketsSPROUTS FARMERS MARSPR AVONDALE AZ$51.954/11/2018
2 Replies
best response confirmed by V A (Copper Contributor)
Solution

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!
1 best response

Accepted Solutions
best response confirmed by V A (Copper Contributor)
Solution

Hi there.

 

Untested.

=SUMIFS($C:$C,$D:$D,">=01.01.2018",$D:$D,"<=31.01.2018",$A:$A,"Services")

 

View solution in original post