CODEWITHSUNDEEP
excelfunctiongoogle-sheets
Agent_Sully
Agent_Sully

Reputation: 295

Total points for each student in Google spreadsheet or excel

I am in the process of creating a Google form, which students will fill out after attending an event. Based on the event they attend, I will be assigning points to them and this form can be submitted through the whole year.

Is there a way to get a total number of points for each students, since they'll be submitting the form multiple times, I need a way to tally up the points for each students

Example spreadsheet goo.gl/1aunYg

Total for Sam: ??? Total for Jon: ??? Total for Mike: ??? Total for Don: ???

Upvotes: 0

Views: 2002

Answers (3)

JPV
JPV

Reputation: 27282

In google spreadsheets, assuming you have the names in Col A and the scores in Col B, you can also try:

=query(A2:B; "select A, sum(B) where A <>'' group by A label sum(B) 'Totals' ")

This should output an array of unique names and the summed scores.

Upvotes: 2

Edward Leno
Edward Leno

Reputation: 6327

Google Spreadsheet see SUMIF

In Excel you could do something like ...

enter image description here

Upvotes: 0

barryleajo
barryleajo

Reputation: 1952

Sort the list on Name (Home>Sort & Filter)

Add a heading for the columns

Apply SubTotals (Data>Subtotal in the Outline group) at each change in Name and using the function Sum.

Example

You can then hide/show individuals using the controls on the LH side.

Upvotes: 0

Related Questions