Sumifs Two Criterias from different columns

Hi,

I am currently making a summary report based on Master data i have created. However i have a problem trying to come up with sumifs formula.
My first condition is the month, Cell A2 from Monthly summary should match Master Data month AA2 to BJ2.
and second condition is the sector, Which appear in Cell A4 to A15 from Monthly summary should match column D in Master data.


My desired result for cell C4 is $1336 (Wilmar, Oct 14 and 0-30 Days) or $68443 (Toll and Oct 14 and 0-30 Days).

Much Appreciated.

Regards.
Albert

Another, similar, approach - also using SUMPRODUCT. The main difference is the value for TOLL. The formula here is picking them all up.

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.