Thanks Biff,

That worked beautifully. I got so locked into using an array formula, I
forgot all about Indirect. Thanks for the help.

tim

Biff wrote:
Hi!

This works in a single formula but requires that you use named ranges.

Assume your headers: RUNS, H, HR are in the range B1:?1

Note: in your post you had "R" as a header. Excel will not accept that as a
name for a range so I changed it to "RUNS".

So, name all the ranges the same as the header. For example:

B1 = RUNS =$B$2:$B$11
C1 = H =$C$2:$C$11
D1 = HR =$D$2:$D$11
etc
etc
etc

Formula to sum total of ranks:

=SUMPRODUCT(RANK(B2:D2,INDIRECT(B$1:D$1)))

I didn't try this on 26 named ranges but I don't see why it wouldn't work.

Biff

"Tim Otero" wrote in message
...

Thanks Vasant,

Usually I can come up with something pretty quick, but this one has me
stumped. thanks again for your help.

Vasant Nanavati wrote:

Sorry; not having a good day today. Will try and think of a more elegant
solution tomorrow!