# Math, Add Rows Together

**URL:** https://community.glideapps.com/t/math-add-rows-together/72902
**Category:** Ask for Help
**Created:** [April 27, 2024, 3:41pm UTC](https://community.glideapps.com/t/math-add-rows-together/72902 "2024-04-27T15:41:41Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![luminrabbit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luminrabbit/32/73584_2.png) [@luminrabbit](https://community.glideapps.com/u/luminrabbit)
#### Post date: [April 27, 2024, 3:41pm UTC](https://community.glideapps.com/t/math-add-rows-together/72902/1 "2024-04-27T15:41:41Z")

</div>

I have a Players table (with Total Points)

 ![Players Table](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/5/856878ec6c9d2ef8e518e13987a6892efb88c552.png)

Then I have another Results table (with Points Earned)

 ![Points](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/5/75aa462223a6cc21b5b5a53cb9bb96aadce1e00a.png)

Im trying to take all of the points Jane Smith has earned in the Results table so far and total that number up in the Players table under Total Points (which would be 2,950 right now she has a place holder of 100).

How would go about this? Thank You!

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 27, 2024, 3:48pm UTC](https://community.glideapps.com/t/math-add-rows-together/72902/2 "2024-04-27T15:48:23Z")

</div>

Create a relation linking the player id in the players table to the player id in the results table. Then create a Rollup column that uses the relation to get a sum of points from results. Then create a math column to add the two values together.

---

<div class="post-metadata">

### Author: ![luminrabbit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luminrabbit/32/73584_2.png) [@luminrabbit](https://community.glideapps.com/u/luminrabbit)
#### Post date: [April 27, 2024, 4:10pm UTC](https://community.glideapps.com/t/math-add-rows-together/72902/3 "2024-04-27T16:10:55Z")

</div>

Hi @Jeff_Hager,

Ive added the relation column in the Players table  
 ![player relation](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b6e46fb325787ea0069e0278b06be3b870e65d29.png)

Then created the rollup column in the Players table and used Sum

 ![Roll up](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/780473fb9ad5e59bc7ec86bb7780b38eab0f0e79.png)

Unfortunately all of the rows have the same number in the Rollup output, anything else I should try?  
It seems to be totaling all of the numbers and not by the player per row.

---

<div class="post-metadata">

### Author: ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)
#### Post date: [April 27, 2024, 4:21pm UTC](https://community.glideapps.com/t/math-add-rows-together/72902/4 "2024-04-27T16:21:04Z")

</div>

1. In the relation column, you must check match multiple.
2. In the rollup column, direct the summarize value option to the relation you created previously, not to the table directly

---

<div class="post-metadata">

### Author: ![luminrabbit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luminrabbit/32/73584_2.png) [@luminrabbit](https://community.glideapps.com/u/luminrabbit)
#### Post date: [April 27, 2024, 4:25pm UTC](https://community.glideapps.com/t/math-add-rows-together/72902/5 "2024-04-27T16:25:09Z")

</div>

Thank you very much @Himaladin  
This is fantastic Ive been trying this for quite sometime and I now see where I was going wrong (I have to go through the relation to the points) absolutely amazing. Thank you so much!

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [May 4, 2024, 4:25pm UTC](https://community.glideapps.com/t/math-add-rows-together/72902/6 "2024-05-04T16:25:20Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.