CODEWITHSUNDEEP
excelms-officesumifs
Meisam Mulla
Meisam Mulla

Reputation: 1871

Multiple SUMIFS in Excel not working as expected

I'm trying to tally up results from another sheet in excel if they match specific criteria. I have successfully looked up and implemented the SUMIF function like so:

=SUMIF('General Expenses'!C:C,"*Office Supplies*",'General Expenses'!D:D)

This returns the expected output. Now I'm trying to use the function SUMIFS to filter using multiple criteria (year & category) ex:

=SUMIFS('General Expenses'!D:D,'General Expenses'!A:A,"*2012*",'General Expenses'!C:C,"Office Supplies")

This does not work as expected and gives me 0 as the value. Below is what the General Expenses sheet looks like:

DATE        PLACE          CATEGORY           AMOUNT
1/1/2012    Staples        Office Supplies    $ 18.40
1/3/2012    Staples        Office Supplies    $  5.63
1/5/2012    Staples        Office Supplies    $ 54.00

Upvotes: 0

Views: 179

Answers (1)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35853

You can use following formula:

=SUMPRODUCT((RIGHT(TEXT('General Expenses'!A:A,"dd/mm/yyyy"),4)="2012")*('General Expenses'!C:C="Office Supplies"),('General Expenses'!D:D))

Upvotes: 2

Related Questions