# How to sum the values in joined list

**URL:** <https://community.glideapps.com/t/how-to-sum-the-values-in-joined-list/34351>\
**Category:** Ask for Help\
**Created:** [November 10, 2021, 4:58pm UTC](https://community.glideapps.com/t/how-to-sum-the-values-in-joined-list/34351 "2021-11-10T16:58:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\
**Post date:** [November 10, 2021, 4:58pm UTC](https://community.glideapps.com/t/how-to-sum-the-values-in-joined-list/34351/1 "2021-11-10T16:58:28Z")

</div>

![JOINED LIST HELP!](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/8028f72fd3ec87d3ac7f45ca02d9a48f2e3e0410.png)

Can anyone please tell me how to add the values in a joined list? the column “experiment bill” contains the values of the total amount and I want to add these figures to get the value of TOTAL BILL for the ORDER. Please help.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [November 10, 2021, 5:05pm UTC](https://community.glideapps.com/t/how-to-sum-the-values-in-joined-list/34351/2 "2021-11-10T17:05:48Z")

</div>

Unfortunately, you can’t perform a summation of a Joined List — you can just count how many items the list contains.

To perform a rollup on the necessary rows, you’ll need to create a relation to those rows and then create a Rollup column that looks at that relation.

Someone else may be able to chime in with a different approach using some of the new experimental code columns, but I haven’t had a chance to use them too much yet.

---

<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:** [November 11, 2021, 12:04am UTC](https://community.glideapps.com/t/how-to-sum-the-values-in-joined-list/34351/3 "2021-11-11T00:04:44Z")

</div>

As @kyleheney said, I don’t think this is the right way to build it. You should use a relation back to your “Cart” (which I think you already have considering you are using joined lists here), then rollup the total bill column on that “Cart” sheet.

The total for each cart item should have been calculated in the “Cart” sheet, not here.

---

<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:** [November 12, 2021, 12:05am UTC](https://community.glideapps.com/t/how-to-sum-the-values-in-joined-list/34351/4 "2021-11-12T00:05:28Z")

</div>

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