Sorting Issues!

[excowboy]

I am trying to manage my hockey league's stats and for the life of me, can't figure out why I can't get things to sort properly. I am sure it's something simple, but I have been at this all day and can't figure out what's missing here.

Trying to use Google sheets to run the stats, but I have attached a sample in Excel, where I am having the same troubles. Basically there are three games on the right hand side which tabulate the players who have scored (G), assisted on a goal (A) and then those two columns are added up to achieve the Points (PTS) column. The GP column notes who played in each game. The games tables on the right feed the season stats table on the left, providing an aggregate total for the year.

I want to be able to be able to select the entire table on the left and then sort it by PTS first. If two players are tied, it would then sort by G, and then again by A.

Ideally, as mentioned, I want to do this in Google sheets as there are two of us in charge of this. Again, I am sure there's something simple at play here, but for the life of me, I can't figure it out!

Thank you very much in advance!

[Bernie Deitrick]

You have the wrong kind of formula - you need to use conditional summing (SUMIFS) and then your table will sort correctly.

The attached should work fine in the googles

[excowboy]

this is awesome and worked like a charm - thanks so much, most appreciated!