CODEWITHSUNDEEP
google-sheetsuniquespreadsheet
Qelvin
Qelvin

Reputation: 13

Making a total of points from a table in Google spreadsheets;unique values have to appear only once

I made this table (the names a,b,c,...of the contestants are dynamic so they change sometimes).

see example 1

Now I want to make a total of the 4 different contests, but the contestants may appear only once and there has to be made a total for each contestant (see desired result)

see desired result

Upvotes: 0

Views: 34

Answers (1)

player0
player0

Reputation: 1

try:

=INDEX(TRIM(FLATTEN(QUERY(TRANSPOSE(E3:H);;9^9))))

then you can do simple:

=INDEX(QUERY({A3:A, 1*TRIM(FLATTEN(QUERY(TRANSPOSE(E3:H),,9^9)))}, 
 "select Col1,sum(Col2) where Col2 is not null group by Col1 label sum(Col1)''", ))

Upvotes: 1

Related Questions