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:
=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
| Services | COX PHOENIX COMM SERV 800-234-3993 AZ03854910 | $72.99 | 3/19/2018 |
| Restaurants | AH SO HAPPY VALLEY PHOENIX AZ | $65.00 | 2/2/2018 |
| Home Improvement | THE HOME DEPOT #0424 PEORIA AZ | $56.24 | 3/16/2018 |
| Supermarkets | SPROUTS FARMERS MARSPR AVONDALE AZ | $55.22 | 3/5/2018 |
| Merchandise | PAYPAL *JUCARDILEMO 402-935-7733 CA | $55.15 | 3/27/2018 |
| Supermarkets | SPROUTS FARMERS MARSPR AVONDALE AZ | $51.95 | 4/11/2018 |
Hi there.
Untested.
=SUMIFS($C:$C,$D:$D,">=01.01.2018",$D:$D,"<=31.01.2018",$A:$A,"Services")
2 Replies
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!
