# How to use Math Column to add multiple lookups from another sheet?

**URL:** <https://community.glideapps.com/t/how-to-use-math-column-to-add-multiple-lookups-from-another-sheet/67821>\
**Category:** Ask for Help\
**Created:** [November 15, 2023, 10:09am UTC](https://community.glideapps.com/t/how-to-use-math-column-to-add-multiple-lookups-from-another-sheet/67821 "2023-11-15T10:09:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![holysheets](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holysheets/32/66286_2.png) [@holysheets](https://community.glideapps.com/u/holysheets)\
**Post date:** [November 15, 2023, 10:09am UTC](https://community.glideapps.com/t/how-to-use-math-column-to-add-multiple-lookups-from-another-sheet/67821/1 "2023-11-15T10:09:22Z")

</div>

Hey all,

I have done a relation to another sheet, and I am using the Lookup option to bring in a bunch of values that are listed for that particular Store ID.

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

Attached is the setup of the tables I have.

I also eventually want to break down the total created in that column into different columns with filtered data → So when I click a Store, I can see how many passes were consumed by customers and staff.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 15, 2023, 10:34am UTC](https://community.glideapps.com/t/how-to-use-math-column-to-add-multiple-lookups-from-another-sheet/67821/2 "2023-11-15T10:34:49Z")

</div>

Is your lookup through a multiple relation?  
If so, you can replace that with a rollup column to get a sum directly.

---

<div class="post-metadata">

**Author:** ![holysheets](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holysheets/32/66286_2.png) [@holysheets](https://community.glideapps.com/u/holysheets)\
**Post date:** [November 15, 2023, 11:01am UTC](https://community.glideapps.com/t/how-to-use-math-column-to-add-multiple-lookups-from-another-sheet/67821/3 "2023-11-15T11:01:57Z")

</div>

I don’t know what I would do without you on this platform. Thanks Darren!

---

<div class="post-metadata">

**Author:** ![holysheets](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holysheets/32/66286_2.png) [@holysheets](https://community.glideapps.com/u/holysheets)\
**Post date:** [November 15, 2023, 1:14pm UTC](https://community.glideapps.com/t/how-to-use-math-column-to-add-multiple-lookups-from-another-sheet/67821/5 "2023-11-15T13:14:10Z")

</div>

What do I have to do if I want to showcase a filter on the SUM of the Total Passes… that is, what if the passes were attached to a category or type, how do I showcase that count of passes in a single category?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 15, 2023, 1:17pm UTC](https://community.glideapps.com/t/how-to-use-math-column-to-add-multiple-lookups-from-another-sheet/67821/6 "2023-11-15T13:17:17Z")

</div>

Replace your multiple relation column with a query column, then you can filter by category.