# Sum lookup values? **URL:** \ **Category:** Ask for Help\ **Created:** [February 27, 2020, 4:32am UTC](https://community.glideapps.com/t/sum-lookup-values/4973 "2020-02-27T04:32:18Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Otis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/otis/32/3480_2.png) [@Otis](https://community.glideapps.com/u/Otis)\ **Post date:** [February 27, 2020, 4:32am UTC](https://community.glideapps.com/t/sum-lookup-values/4973/1 "2020-02-27T04:32:18Z")
I’m probably just missing how to do this, but is there a way to add the values returned in a lookup cell? I have multiple rows with different data in one column. Is there a way to pull those values in and add them (SUM) in a different sheet? I’ve used the lookup functionality to pull these numbers into a single cell based on the relational data, but I’m stuck on how to add these together into a single result/cell from here. ie, Rather than having 1 5 10 as three separate numbers, how do I get a cell that shows 16 based on what I’m pulling in with the relational/lookup pulls. ---
**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 27, 2020, 4:33am UTC](https://community.glideapps.com/t/sum-lookup-values/4973/2 "2020-02-27T04:33:40Z")
I had the same question. Don’t use the lookup, use the relation column. > [@Sum multiple lookup values using rollup](https://community.glideapps.com/t/sum-multiple-lookup-values-using-rollup/4588): > > 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] ---
**Author:** ![Otis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/otis/32/3480_2.png) [@Otis](https://community.glideapps.com/u/Otis)\ **Post date:** [February 27, 2020, 4:41am UTC](https://community.glideapps.com/t/sum-lookup-values/4973/3 "2020-02-27T04:41:58Z")
Thanks for the help and the quick reply. I saw your question, but I am unable to figure this out even from the response. The values are all different (and will be all across the board) - so how do I pull them in with a relation column? (I’ve used relations to gather inline lists, but not add/sum together). ---
**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 27, 2020, 12:36pm UTC](https://community.glideapps.com/t/sum-lookup-values/4973/4 "2020-02-27T12:36:32Z")
You mentioned using a lookup to gather all the numbers into a single column based of off relational data. Create a Rollup column that summarizes the value of this relation by sum. If you cane figure it out, could you post a screen shot? ---
**Author:** ![Otis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/otis/32/3480_2.png) [@Otis](https://community.glideapps.com/u/Otis)\ **Post date:** [February 27, 2020, 7:14pm UTC](https://community.glideapps.com/t/sum-lookup-values/4973/5 "2020-02-27T19:14:19Z")
Here’s a few screen shots. In one sheet called “Bids” you can see the Cost column uses Math to calculate the cost for each row. The relations Column then shows which “Bid” these each belong to. In a separate tab called “Projects” I have used the Lookup function to pull in each of these costs columns. I can’t use a Rollup in the Projects tab to select the "Total Bid Costs (Lookup) Column. If I use the rollup functionality in the bid sheet, it gives me the total costs for all bids, but not broken out by the relations or bid name. It sounds like you have an answer, but I’m not putting it together myself. Do these screen shots help? Any other ideas? Thanks for the help. ![Screen Shot 2020-02-27 at 11.08.31 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0e220413f95694e41fab41840e1bfb2249158584.png) ![Screen Shot 2020-02-27 at 11.08.52 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a52ae0397e5e0f6300c34ee3bf0e752e0a43151f.png) ---
**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 27, 2020, 8:15pm UTC](https://community.glideapps.com/t/sum-lookup-values/4973/6 "2020-02-27T20:15:23Z")
Yes. Can you do a Rollup (not lookup) by Relations (Green/Joni/Morgan) where you’re summing the Cost? ---
**Author:** ![Otis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/otis/32/3480_2.png) [@Otis](https://community.glideapps.com/u/Otis)\ **Post date:** [February 27, 2020, 10:09pm UTC](https://community.glideapps.com/t/sum-lookup-values/4973/7 "2020-02-27T22:09:59Z")
I don’t believe I can do a Rollup by one column (relations) where I SUM a different column (Costs) can I? When I create a Rollup and choose the Room Costs it rolls up the entire column (for all rooms). Is there a way to restrict this Rollup? Perhaps I’m not fully understanding Rollup well enough. ![Screen Shot 2020-02-27 at 2.07.30 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1caa3e96c02d2c69e34cb40265906d5ab07273f4.png) ---
**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 27, 2020, 10:13pm UTC](https://community.glideapps.com/t/sum-lookup-values/4973/8 "2020-02-27T22:13:21Z")
When setting up your Rollup column, scroll all the way down on the ‘summarize the values of’ dropdown. You should see your relation. Select that instead of the sheet name. ---
**Author:** ![Otis](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/otis/32/3480_2.png) [@Otis](https://community.glideapps.com/u/Otis)\ **Post date:** [February 27, 2020, 10:21pm UTC](https://community.glideapps.com/t/sum-lookup-values/4973/9 "2020-02-27T22:21:48Z")
That was it! I wasn’t scrolling down to see the relations (prior to looking at the Sheets). Wow - thank you both very much for the help. Such a simple solution that had me stumped for the past two days on how to best solve. Thank you, thank you, thank you. ---
**Author:** ![Mang\_Yun](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mang_yun/32/65081_2.png) [@Mang\_Yun](https://community.glideapps.com/u/Mang_Yun)\ **Post date:** [March 21, 2024, 2:26am UTC](https://community.glideapps.com/t/sum-lookup-values/4973/10 "2024-03-21T02:26:15Z")
just to add more clarity for others… **Do not** select column from your table, use column from your **relation**. these problem got me stuck for a day. btw, i am new to glide, just start exploring yesterday. will need a lot more help from the community … ![Screenshot 2024-03-21 102259](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a6eebf457a5ada462206058ad073cc404da638de.png)