# How to sum up different amounts for each item?

**URL:** <https://community.glideapps.com/t/how-to-sum-up-different-amounts-for-each-item/36209>\
**Category:** Ask for Help\
**Created:** [December 21, 2021, 10:49pm UTC](https://community.glideapps.com/t/how-to-sum-up-different-amounts-for-each-item/36209 "2021-12-21T22:49:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dave](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dave/32/36387_2.png) [@Dave](https://community.glideapps.com/u/Dave)\
**Post date:** [December 21, 2021, 10:49pm UTC](https://community.glideapps.com/t/how-to-sum-up-different-amounts-for-each-item/36209/1 "2021-12-21T22:49:53Z")

</div>

Hi Community!

I have an unsolved problem that is blowing my brain! Have you felt thist way before?

I am working with product purchases and I need to know the total quantity of each item purchased.

Ex:

ITEM QTY DATE  
item1 2 10/10  
item2 5 10/10  
item1 1 10/11

As you see, the right answer is:

item1 = 3  
item 2 = 5

I was trying Rollup, but it’s not working.

What would you do?

Thnx!!

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [December 21, 2021, 11:20pm UTC](https://community.glideapps.com/t/how-to-sum-up-different-amounts-for-each-item/36209/2 "2021-12-21T23:20:58Z")

</div>

you need to relate items to sold items, then use the rollup column to sum that relation

 ![Screen Shot 2021-12-21 at 6.22.41 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/b/2bf151b8d2f4e1f14292dc63fe899341f7ebe0e5.png)

 ![Screen Shot 2021-12-21 at 6.26.52 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/6/6643954465b4e48fdacb3dee67e4c885da15918b.png)

remember… sum relation, not a lookup, I put lookup there just for better understanding what is in the sold sheet…  
you can also use this technique to count sold items, get average or range …

---

<div class="post-metadata">

**Author:** ![Dave](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dave/32/36387_2.png) [@Dave](https://community.glideapps.com/u/Dave)\
**Post date:** [December 22, 2021, 2:52am UTC](https://community.glideapps.com/t/how-to-sum-up-different-amounts-for-each-item/36209/3 "2021-12-22T02:52:30Z")

</div>

Hi Mate!!

I worked!

Thank you so much!