I need help with creating an array formula for a spreadsheet I'm developing. The percentages are constants. In the calculated total column I want the sum of 100%*10 + 88%*20 + 68%*29 + 50%*15 + 20%*6 for each line. Any help or guidance will be greatly appreciated. - Fred
<tbody>
</tbody>
100% | 88% | 68% | 50% | 20% | Calculated Total | |
1 | 10 | 20 | 29 | 15 | 6 | |
2 | 30 | 30 | 0 | 0 | 20 | |
3 | 150 | 0 | 0 | 0 | 10 | |
4 | 500 | 0 | 100 | 120 | ||
<tbody>
</tbody>