Hi, your post is a little unclear... what are you trying to return ? The rank of the SUM of each person ? If so I'd suggest creating another column to consolidate and rank that, ie:

Sheet13

A B C D E F G H 1 1 Jack 156 Jack 157.04 Jack 99.12 412.16 2 2 Joe 131.28 Joe 150.79 Joe 92.56 374.63 3 3 Mary 128.93 Mary 128.94 Mary 66.06 323.93 4 4 Mark 124 Mark 101.31 Mark 52.43 277.74

Spreadsheet Formulas

Cell Formula A1 =RANK($H1,$H$1:$H$4,0) H1 =SUM(C1:G1)

Excel tables to the web >> Excel Jeanie HTML 4

If that's not what you want please elaborate.

## Like this thread? Share it with others