Formula for calculating positions

[0-0 Wai Wai ^-^]

Hi.
I have a worksheet like the following:
Player's Name-----Round1(R1)-----R2-----R3...-----Total Score====Position after
R1-----Pos.(R2)-----Pos.(R3)...

Position is calculated based on the score accumalted (the more scores, the
better) so far.
Eg: Postion after R1 depends on score got in R1.
Position after R2 depends on score got in R1 & R2.
Position after R3 depends on score got in R1 & R2 & R3.

Q: What formulas should I use to calculate the positions up to different rounds?
I think I can use RANK functions, but it seems I need to set SUM formulas to
calculate total scores up to different rounds (ie R1, R1+R2, R1+R2+R3 etc.)
first. It seems to be clumsy.
At best, I would need to set one formula only in "position after R1/R2/R3"
columns witohut the need to set SUM formulas separately.
Any suggestion?

 

[Domenic]

Assuming that A1:H10 contains your table, and that the first row
contains your headers/labels, try...

F2, copied across and down:

=IF(COUNT($B$2:B$10)=COUNTA($A$2:$A$10)*COLUMNS($F2:F2),SUMPRODUCT(--(SUM
($B2:B2)<SUBTOTAL(9,OFFSET($B$2:B$10,ROW($B$2:B$10)-ROW($B$2),0,1))))+1,"
")

However, it would be more efficient to have separate totals for each
round and then use RANK.

Hope this helps!