# Total only selected rows

**URL:** <https://community.glideapps.com/t/total-only-selected-rows/26332>\
**Category:** Ask for Help\
**Created:** [May 3, 2021, 8:22am UTC](https://community.glideapps.com/t/total-only-selected-rows/26332 "2021-05-03T08:22:27Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Amal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/amal/32/15421_2.png) [@Amal](https://community.glideapps.com/u/Amal)\
**Post date:** [May 3, 2021, 8:22am UTC](https://community.glideapps.com/t/total-only-selected-rows/26332/1 "2021-05-03T08:22:27Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [May 3, 2021, 8:26am UTC](https://community.glideapps.com/t/total-only-selected-rows/26332/2 "2021-05-03T08:26:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [May 3, 2021, 8:30am UTC](https://community.glideapps.com/t/total-only-selected-rows/26332/3 "2021-05-03T08:30:02Z")

</div>

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

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bb533853be3eb2f552fe050ab1897ebb14f7d216.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/0/60b36f9d5ea1f61158cc584f1525c717d2edc16c.png)

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eb40982045ea908ccf311347c504b525779c71c5.png)

---

<div class="post-metadata">

**Author:** ![Amal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/amal/32/15421_2.png) [@Amal](https://community.glideapps.com/u/Amal)\
**Post date:** [May 3, 2021, 9:41am UTC](https://community.glideapps.com/t/total-only-selected-rows/26332/4 "2021-05-03T09:41:22Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [May 3, 2021, 9:42am UTC](https://community.glideapps.com/t/total-only-selected-rows/26332/5 "2021-05-03T09:42:19Z")

</div>

Yes

---

<div class="post-metadata">

**Author:** ![Amal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/amal/32/15421_2.png) [@Amal](https://community.glideapps.com/u/Amal)\
**Post date:** [May 3, 2021, 9:53am UTC](https://community.glideapps.com/t/total-only-selected-rows/26332/6 "2021-05-03T09:53:20Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Amal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/amal/32/15421_2.png) [@Amal](https://community.glideapps.com/u/Amal)\
**Post date:** [May 3, 2021, 10:00am UTC](https://community.glideapps.com/t/total-only-selected-rows/26332/7 "2021-05-03T10:00:33Z")

</div>

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