Calculate Cumilative total depending on the Rank

[Asoka Walpitagama - Brandix College IT]

Hi
How do I calculate the Cumilative total ( ?? ) depending on the rank as show
below. I have given the way it should be calculeted in the 'RESULT SHOULD BE'
column

RANK Length Cum Tot RESULT SHOULD BE
2 65 ?? 70+65 ( Cum.tot of Ranks 1 + 2 )
3 60 ?? 70+65+60 ( Cum.tot of Ranks 1 + 2 +
3 )
1 70 ?? 70 ( Cumilative total
of Rank 1 )
5 45 ?? 70+65+60+55+45 (Cum. tot of Ranks
1+2+3+4+5)
4 55 ?? 70+65+60+55 ( Cum. tot of Ranks
1+2+3+4 )

 

[Luke M]

You could use this array* formula in cell C2:

=SUM(IF(A2-A$2:A$6>=0,B$2:B$6))

and then copy down.

*Use Ctrl+Shift+Enter to confirm formula, not just enter.