Summing a product with selection Criteria

[cjbirm]

I'm trying to make a table that will sum a the product of a value and probability based on a criteria value in another column. The table below is an example of what I'm trying to do:

Criteria	Prob	2019	2020	2021	2022
X	100%	41	10	75	150
X	90%		24	24	24
Y	65%		53	160
X	70%		25
X	70%

<tbody>
</tbody>

	2019	2020	2021	2022
X	41	49.1	96.6	171.6
Y	0	34.45	104	0

<tbody>
</tbody>

Instead of just hard-coding the SUM and Product function in the bottom table, I would like to use equations so I can just add more rows or columns to the top table and have the bottom table automatically update. If tried playing around with the PRODUCT, IF, and SUMIF equations, but I can't seem to get any of them to work.

Any suggestions?

 

[BlueHornet]

You'll want to know about SUMPRODUCT:
=SUMPRODUCT(( $A$3:$A$7 = $A10) * ( $B$3:$B$7) * ( C$3:C$7))

Enter the formula in the bottom table for X for 2019 and copy throughout the table.

 

[cjbirm]

Worked great, thanks for the help.