PDA

View Full Version : Multiple Conditional (SUMIF) Formula

Francis Gerard Tupaz
2012-07-24, 11:43 AM

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

tommyt61
2012-07-24, 04:44 PM
unless i am not understanding correctly ... this should work for you.

=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.