I have two set of tables:
1) In the first table I have a series of percentages associated each with a code (e.g. C2, C18, C20):
<tbody>
</tbody>
2) In the second table I have values associated with the same codes as in the first table (i.e. C2, C18, etc):
<tbody>
</tbody>
What I would like to do is to multiply the percentage values in Table 1 by the values in Table 2 that are associated with the same Cx code and sum them all (i.e. 20%*100+16%*15+20%*50, etc.).
I have tried using sumproduct and sumproduct with INDEX MATCH but could not make it work...
Many thanks!
1) In the first table I have a series of percentages associated each with a code (e.g. C2, C18, C20):
C2 | C18 | C20 | C12 | C5 | C6 |
20% | 16% | 20% | 5% | 4% | 12% |
<tbody>
</tbody>
2) In the second table I have values associated with the same codes as in the first table (i.e. C2, C18, etc):
C2 | C12 | C6 | C3 | C9 | C18 | C5 | C20 |
100 | 234 | 25 | 17 | 27 | 15 | 30 | 50 |
<tbody>
</tbody>
What I would like to do is to multiply the percentage values in Table 1 by the values in Table 2 that are associated with the same Cx code and sum them all (i.e. 20%*100+16%*15+20%*50, etc.).
I have tried using sumproduct and sumproduct with INDEX MATCH but could not make it work...
Many thanks!