Total only selected rows

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.

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

1 Like

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

image

image

1 Like

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

Yes

1 Like

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

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