Thursday, October 20, 2011

yogi_Compute For Unique Names Totals By Specified Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
user alter73 said:
I am working on spreadsheet which is a result of a publicated form, it looks simplified like this:
(1) X 100
(2) Y 130
(3) Z 160
I can do a formula that filter only one distance and shows sorted list of players best times on this distance.
But I have no idea how to make a sorted list of players with total time (sum of results for distance 10 and 20). The best solution I know to have such a sorted list is "SORT" and "FILTER" formula but the biggest problem is how to also calculate this SUM of results in column C for every player.
This should be automatically working for larger data base with more players who provide their results using publicated form linked with this spreadsheet.