Assuming that for each row you'd like the sum of the row to be ranked
against the sum of each row, try...

=SUMPRODUCT(--($A$2:$A$10=A2),--(SUM(B2:E2)<SUBTOTAL(9,OFFSET($B$2:$E$10,
ROW($B$2:$E$10)-ROW($B$2),0,1))))+1

Note that SUMPRODUCT does not accept whole column references.

Hope this helps!

In article . com,
"S Davis" wrote:

Sad to report that the information I am trying to rank is spread across
more than one column.

Right now Im using this formula:

=SUMPRODUCT(--(A:A=A4),--(N4<B:B))+1

... can this be modified to take into account C:C, D:D, and E:E, so
that A4 is ranked out of the results of all of those columns?