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 …

Yes. Can you do a Rollup (not lookup) by Relations (Green/Joni/Morgan) where you’re summing the Cost?

I had the same question. Don’t use the lookup, use the relation column. [image] Sum multiple lookup values using rollup Feature Requests 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 us…

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 tog…

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?

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 column…

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. […

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.

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.

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]

Sum lookup values?

Ask for Help

Robert_Petitto February 27, 2020, 4:33am 2

I had the same question. Don’t use the lookup, use the relation column.

Topic		Replies	Views
Make a sum from look up column Ask for Help	6	814	April 19, 2020
Sum Values for each Row Using Rollup Ask for Help	15	3538	October 3, 2020
Sum multiple lookup values using rollup Feature Requests	3	886	February 14, 2020
Adding the numbers in lookup Ask for Help	2	297	January 12, 2023
How to use Math Column to add multiple lookups from another sheet? Ask for Help	4	166	November 15, 2023

Sum lookup values?

Related topics