# Sum multiple lookup values using rollup

**URL:** <https://community.glideapps.com/t/sum-multiple-lookup-values-using-rollup/4588>\
**Category:** Feature Requests\
**Created:** [February 14, 2020, 3:47am UTC](https://community.glideapps.com/t/sum-multiple-lookup-values-using-rollup/4588 "2020-02-14T03:47:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 14, 2020, 3:47am UTC](https://community.glideapps.com/t/sum-multiple-lookup-values-using-rollup/4588/1 "2020-02-14T03:47:45Z")

</div>

I have a multiple relation column that’s feeding a lookup column of number values (“Player XP”). I want to total them for each row using the rollup (“Total XP”), but the lookup column is unavailable from the list of available columns. Is this a bug or limitation?  
 ![Screen Shot 2020-02-13 at 10.43.30 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/9a7bee9c8912bbb033c542a8d0330151649644b9.png)

 ![Screen Shot 2020-02-13 at 10.44.03 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/68a30efd713141d39fea20ecf1ee50d7c6146615.png)

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [February 14, 2020, 3:58am UTC](https://community.glideapps.com/t/sum-multiple-lookup-values-using-rollup/4588/2 "2020-02-14T03:58:49Z")

</div>

This is a limitation. We’ll make that possible eventually.

---

<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:** [February 14, 2020, 4:48am UTC](https://community.glideapps.com/t/sum-multiple-lookup-values-using-rollup/4588/3 "2020-02-14T04:48:02Z")

</div>

When setting up your rollup column, all relations are at the bottom of the “Summarize the Values of” dropdown. You should be using that to select the relation and XP column instead of using the Lookup column. Unless I’m misunderstanding something.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [February 14, 2020, 11:08am UTC](https://community.glideapps.com/t/sum-multiple-lookup-values-using-rollup/4588/4 "2020-02-14T11:08:37Z")

</div>

Genius.  
 ![Screen Shot 2020-02-14 at 6.07.58 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/40acba35901c70014ba1e808d8bcb9a19ff59d7d.png)

---

<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:** [April 28, 2024, 6:13am UTC](https://community.glideapps.com/t/sum-multiple-lookup-values-using-rollup/4588/5 "2024-04-28T06:13:13Z")

</div>