formula taking 2 criteria?

Hello,

I need to find a formula that can have two criteria.

I want to transfer data from one table to another table (see attachment).

I use the SUMIF formula, but this formula can only take one criteria. My criteria should be the left column (the numbers) and the top row (the titles). So, in table B if both of these criteria are met, then data can be transfered from table A to table B.

The formula must be set to table B.

So in my example, only the number 30 must be transferred in table B.

Can you help me?

Thanks

ssuming table 1 in cells A12:F9 and table 2 in A12:E18 then one way is to use this formula in B13 copied across and down

=SUMIF($A$3:$A$9,$A13,INDEX($B$3:$F$9,0,MATCH(B$12,$B$2:$F$2,0)))