Results 1 to 2 of 2

Thread: Multiple Conditional (SUMIF) Formula

  1. #1

    Multiple Conditional (SUMIF) Formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

  2. #2
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •