Thanks Domenic,

I regrettingly rearranged my entire workbook to put those columns in
need of ranking beside each other. Its a little more confusing to look
at, but it now at least works (can set all 4 columns to one range) and
I can summarize on another sheet with simple references (=).

Thanks for all the help everyone.
-S

Domenic wrote:
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?