The higher goals scored are ranked better:

=RANK(A1,A$1:A$10)+SUMPRODUCT(--(A1=A$1:A$10),--(B1<B$1:B$10))+SUMPRODUCT(--(A1=A$1:A$10),--(B1=B$1:B$10),--(C1<C$1:C$10))

Biff

wrote in message
ups.com...
thanks, biff.

would it be possible to add a third ranking criteria? say two teams
are tied for both wins and goals scored, so i want to break that tie
in a third column (say, C1:C10) which is goals scored at home.

thanks!!

-adh