Which car is ahead?

Hiii,

I have attached a sheet inorder to understand better.

in the column ahead, i need a formula that can compare the km covered by car a and car b and decide which car is ahead?

as i come down the array it should sum the previous km covered and then compare.

Many thanks

Or this:

Formula:

Please Login or Register  to view this content.

I think that E4 should return "tie"

Thanks a lot

=INDEX({"car b","tie","car a"},MATCH(SIGN(SUM(B$2:B2)-SUM(C$2:C2)),{-1,0,1}))
copy down

Ghozi, you don't need MATCH function...
It's enough to add +2 on SIGN result

Formula:

Please Login or Register  to view this content.

Since SIGN can return -1, 0 or 1 by adding +2 you will have 1,2,3 that you can use in your INDEX function.

Compare to mine solution above.

thank's a lot