Hi
Could really do with some assistance on this one ...svp
Table below . . . to achieve 16000 in A3 I've calc'd as follows; =$B3*((D3*E3)+(F3*G3)+(H3*I3)+(J3*K3)+(L3*M3)) ... this works but is 'long-hand' and doesn't address the rate changes in columns B & C.
Does anyone know a way of using 'sumproduct' or similar to show me how to calculate this using a better formula?
atb
Simon.
<tbody>
</tbody>
Could really do with some assistance on this one ...svp
Table below . . . to achieve 16000 in A3 I've calc'd as follows; =$B3*((D3*E3)+(F3*G3)+(H3*I3)+(J3*K3)+(L3*M3)) ... this works but is 'long-hand' and doesn't address the rate changes in columns B & C.
Does anyone know a way of using 'sumproduct' or similar to show me how to calculate this using a better formula?
atb
Simon.
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
1 | wk1 | wk2 | wk3 | wk4 | wk5 | |||||||||
2 | total cost | day rate | wend rate | Qty | Days | Qty | Days | Qty | Days | Qty | Days | Qty | Days | |
3 | 16000 | 100 | 250 | 8 | 5 | 8 | 5 | 8 | 5 | 8 | 5 | |||
4 | 4000 | 100 | 250 | 2 | 5 | 2 | 5 | 2 | 5 | 2 | 5 | |||
5 | 2000 | 100 | 200 | 2 | 5 | 2 | 5 | 5 | 5 | |||||
6 | ||||||||||||||
7 | ||||||||||||||
8 |
<tbody>
</tbody>