I have a spreadsheet (technically a Google Sheet) I transcribed from a script of a musical. Each line is its own row, and has the name of the person who said it and the number of words in the line in the same row.

I want to make a list of people who have lines sorted by the total number of words they've said. What functions can I use to do this?

2 Answers 2


I'm guessing people's names appear multiple times, so suggest a pivot table:

WA108271 example

Bod added to ROWS and Words added to VALUES with Summarise by SUM.

Sorting is by Bod by default but can be by Sum of Words, either ascending or descending.


You can use the sort functionality from the Data menu, if it's a one-time thing, or the =SORT() function.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.