Francis Gerard Tupaz
Member
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
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