Calculate Cumilative total depending on the Rank

  • Thread starter Asoka Walpitagama - Brandix College IT
  • Start date
A

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 )
 
L

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top