Sorting data with formulas in cells

[Nick Roydhouse]

Hi,

I'm trying to sort the table at the top of the excel worksheet from Largest value to smallest, but am having a problem as the Wins column values are generated through formulas. Can any body help me?

Thanks

[JBeaucaire]

1) Put this formula in D4 and copy down:
=SUMIF($C$15:$C$50, C4, $B$15:$B$50)+SUMIF($F$15:$F$50, C4, $E$15:$E$50)

2) Fix the values in C4:C12 so the text there is exactly the same text as in HOME/AWAY columns. For instance, it's " Massachusetts", not UMass. And it looks like they all have two blank spaces in the lead... make them match exactly.

3) Now you can sort C4:D14 by column D.

[Nick Roydhouse]

Perfect,

Thank you