I think something along these lines...
| A | B |
---|
1 | Service Plan | Cost |
2 | Service 1 | 76.78 |
3 | Service 2 | 27.61 |
4 | Service 3 | 64.64 |
5 | Service 4 | 59.81 |
6 | Service 5 | 41.74 |
7 | Service 6 | 10.17 |
8 | | |
9 | Level | |
10 | Service 3 | 169.03 |
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2
Worksheet Formulas
Cell | Formula |
---|
B10 | =SUM(B2:INDEX(B2:B7,MATCH(A10,A2:A7,0))) |
---|
<thead>
</thead><tbody>
</tbody> |
<tbody>
</tbody>