25% | 1 | 2000 |
15% | 2 | 1200 |
4% | 3 | 320 |
4% | 4 | 320 |
4% | 5 | 320 |
4% | 6 | 320 |
4% | 7 | 320 |
3% | 8 | 240 |
3% | 9 | 240 |
3% | 10 | 240 |
3% | 11 | 240 |
3% | 12 | 240 |
3% | 13 | 240 |
3% | 14 | 240 |
3% | 15 | 240 |
3% | 16 | 240 |
3% | 17 | 240 |
3% | 18 | 240 |
2% | 19 | 160 |
2% | 20 | 160 |
2% | 21 | 160 |
1% | 22 | 80 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
criteria : 78%
First I want Excel To check where 78% would be from column A (ie : num 13 ) and then excel should sum from 1-13 from column c and give the desired result