Total only selected rows

Help & How To
#1

Hi Gliders,

I have a multiple teams setup, and i want a way, to total up scores of selected teams(rows), not the whole column.

I have a column which is user specific (admin) when a button is clicked it writes a ‘1’ to show the team is selected, i need to find a way to now add the total of only ones which are been selected.

#2

Sounds like you need an extra relation, then rollup a count/sum on that relation.

1 Like
#3

Simple use 1 relation column then a Count column
Here is a small example

image

image
image876×390 30 KB

image

1 Like
#4

Thank you, is the relation to itself? same sheet?

#5

Yes

1 Like
#6

What i need is, that a admin picks which two teams to tally scores for.

#7

Anyone have the time to do a short zoom call to help?