SUMIF/LOOKUP help

I've attached a file that is similar to something that I'm working on.

I'm attempting to create a formula that will sum only the amount spent on foods that are found in the west district. I've tried my hand at SUMIFS, SUMPRODUCT, CSE, and I still can't create a formula that will work. Granted, I'm still only a novice excel user, so I'm hoping someone with some better excel skills can help me out.

My best guess is that to sum the data that meets the requirements in the first set of data I will need to utilize some form of lookup on the second data set, but am having a difficult time creating the necessary formula.

Can anyone help?

Test.xlsx

Originally Posted by Ace_XL

Try...

=SUMPRODUCT(COUNTIFS($G$2:$G$12,$A$2:$A$6,$H$2:$H$12,"West"),$B$2:$B$6)

THANKS SO MUCH!!!!

That worked perfectly!!!!