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:
<tbody>
</tbody>
<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?
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?