Multiple Conditional (SUMIF) Formula

Joined
Jun 4, 2012
Messages
30
Reaction score
0
Points
0
Location
Philippines
Excel Version(s)
2011
Dear Sir/Madam,

May I again request for your help please? I am trying to configure a formula which will compute from a range of data all "CREDIT CARD" purchases under "EURO" currency but it captures everything? I have attached herewith the working excel sheet and below is the formula I tried formulating.

=IF(SUMIFS('Source Data'!$D$2:$D$127,'Source Data'!$F$2:$F$127,"CREDIT CARD"),SUMIF('Source Data'!$E$2:$F$127,"AUD",'Source Data'!$D$2:$D$127))

Logic:
=SUM IF range is equals to credit card aud currency
=sum if range is equals to paypal aud currency
etc.

It would be nice if its under one long formula but at this desperation any will do.
Thank you very much!

Regards,

Francis
 

Attachments

  • Sample Worksheet.xlsx
    41.3 KB · Views: 20

tommyt61

New member
Joined
Mar 26, 2011
Messages
153
Reaction score
0
Points
0
unless i am not understanding correctly ... this should work for you.


Code:
=SUMIFS('Source Data'!$D$2:$D$127,'Source Data'!$F$2:$F$127,"CREDIT CARD",'Source Data'!E2:E127,"EUR")


of course all you have to do is change Credit Card to Pay Pal in the Pay Pal column wallet the same.
 
Top