Using RANK across multiple columns

[NICKRENN]

Hi

I have a table with 4 columns of "scores" its needs to be laid out like that as its 4 phases of a cycle.

What i would like to do is rank the scores across all 4 columns.

Column C, F I and L have Scores and i would like the Ranking next to those scores in Columns D,G,J and M.

i'm doing two variations of this, in the first its simple, just by column, so i have the Formula: =RANK(C5,$C$5:$C$30)

now i need something that does: =RANK(C5, C5:C30+F5:F30+I5:I30+L5:L30)

Any ideas?

Thanks

Nick