Apr 27 2018
11:00 PM
- last edited on
Jul 25 2018
11:51 AM
by
TechCommunityAP
Apr 27 2018
11:00 PM
- last edited on
Jul 25 2018
11:51 AM
by
TechCommunityAP
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 |
Apr 27 2018 11:15 PM
SolutionHi there.
Untested.
=SUMIFS($C:$C,$D:$D,">=01.01.2018",$D:$D,"<=31.01.2018",$A:$A,"Services")
Apr 28 2018 08:53 AM
Apr 27 2018 11:15 PM
SolutionHi there.
Untested.
=SUMIFS($C:$C,$D:$D,">=01.01.2018",$D:$D,"<=31.01.2018",$A:$A,"Services")