using multiple criteria with sumif

is it possible to use two criteria in with a sumif function?

what I want to do is sum a range of numbers if a location code matches and a currency code matches.

example WS

location code Currency Code inventory
1 $
3 $
1 Y
1 $
3 Y

I want to sum all the inventory for the amounts with location code+ 1 and currency = $.

I can get a sumif function to work using one criteria ie sumif location code matches but I am having trouble excluding the numbers I don't want.

thank you for any help

I found this example online

Sum of Sales where Month="Jan" AND Region="North"
For multiple criteria in different fields, the SUMIF function doesn't work. However, you can use an array formula. When you enter this formula, use Ctrl+Shift+Enter:

=SUM((A2:A10="Jan")*(B2:B10="North")*C2:C10)

so would mine look like

=sum((location code range = desired location code) * (currency code range = desired currency code) * range I want to sum) ?

ok that worked! I got hung up for awhile by not using ctr+sht+enter but once I did that I got it.

Hello Jerhansen277, is this a private thread or can anyone join in?

You could avoid CTRL+SHIFT+ENTER if you use SUMPRODUCT, i.e.

=SUMPRODUCT((A2:A10="Jan")*(B2:B10="North"),C2:C10)