| Book1 | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | 0.5 | 1 | 1.5 | Total | |||
| 2 | 19 | 5 | 14 | 16.5 | |||
| 3 | 24 | 4 | 19 | 1 | 20.5 | ||
| 4 | 6 | 6 | 6 | ||||
| 5 | 4 | 3 | 1 | 4.5 | |||
Sheet1 | |||||||
Above is a sample of a spreadsheet I have constructed.
Everything I need is working fine except the Total column. I have tried various formulas but struggled to find the correct solution to give me the answer I require.
Basically the total column is a sum of the first 20 results in column B,C & D using the multiplier in row 1.
Order of preference is column D first followed by C followed by B. Row 3 for example only column D and C are to be used in the total calculation.
Any help would be greatly appreciated
