# Add Quantities from Two Separate Sheets

**URL:** <https://community.glideapps.com/t/add-quantities-from-two-separate-sheets/25829>\
**Category:** Ask for Help\
**Created:** [April 21, 2021, 12:31am UTC](https://community.glideapps.com/t/add-quantities-from-two-separate-sheets/25829 "2021-04-21T00:31:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![AjBruce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ajbruce/32/12937_2.png) [@AjBruce](https://community.glideapps.com/u/AjBruce)\
**Post date:** [April 21, 2021, 12:31am UTC](https://community.glideapps.com/t/add-quantities-from-two-separate-sheets/25829/1 "2021-04-21T00:31:27Z")

</div>

I need help with setting this up. I am wanting to auto-calculate item quantities from two separate sheets. It seems fairly simple, but I’ve tried several logics and I cannot move forward.

I’ve tried creating a relation between both sheets using the “Current Stock” columns, but the relation output is showing the items.

Again, just want both “Current Stock” columns to output a total calculations between the two. Also, would I need to have the Item names to match?

Thanks,  
AJ

**Sheet A**  
 ![Screen Shot 2021-04-20 at 7.23.03 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c97cfd8799cb74ba87caefc6deb6f0f42d4f6321.png)

**Sheet B**  
 ![Screen Shot 2021-04-20 at 7.22.33 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/9/290eb3a5fbe9859a5d3a4ea69903fec7d2bd7191.png)

---

<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:** [April 21, 2021, 1:13am UTC](https://community.glideapps.com/t/add-quantities-from-two-separate-sheets/25829/2 "2021-04-21T01:13:50Z")

</div>

> [@AjBruce](#):
>
> I’ve tried creating a relation between both sheets using the “Current Stock” columns, but the relation output is showing the items.

The relation’s visual presentation is just a way to show that it finds a match, or multiple matches, not the actual value you’re getting back.

Let’s say you want to calculate the total in Sheet A, create a relation to sheet B and return the actual count in Sheet B using a lookup, then a math column to add the two stock counts together.

I would advise using a reliable column as the connector for the relation. Usually I use IDs, but if you’re confident your items won’t ever have a duplication then just go ahead.

---

<div class="post-metadata">

**Author:** ![AjBruce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ajbruce/32/12937_2.png) [@AjBruce](https://community.glideapps.com/u/AjBruce)\
**Post date:** [April 21, 2021, 2:01am UTC](https://community.glideapps.com/t/add-quantities-from-two-separate-sheets/25829/3 "2021-04-21T02:01:59Z")

</div>

Thanks ThinhDinh! I’ve been beating myself up on this and yes it appears I made it much more complex then I needed to. 😆 As far as duplication, IDs would be ideal… 👍

---

<div class="post-metadata">

**Author:** ![AjBruce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ajbruce/32/12937_2.png) [@AjBruce](https://community.glideapps.com/u/AjBruce)\
**Post date:** [April 21, 2021, 2:03am UTC](https://community.glideapps.com/t/add-quantities-from-two-separate-sheets/25829/4 "2021-04-21T02:03:48Z")

</div>

Also to include, the Item names needed to match for the relation to pull the counts.

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/add-quantities-from-two-separate-sheets/25829/5 "2024-01-17T16:52:32Z")

</div>