# Sum from different table **URL:** \ **Category:** Ask for Help\ **Created:** [June 10, 2024, 1:31am UTC](https://community.glideapps.com/t/sum-from-different-table/74000 "2024-06-10T01:31:32Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![tommyrepi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tommyrepi/32/76354_2.png) [@tommyrepi](https://community.glideapps.com/u/tommyrepi)\ **Post date:** [June 10, 2024, 1:31am UTC](https://community.glideapps.com/t/sum-from-different-table/74000/1 "2024-06-10T01:31:32Z")
I want to take data from a specific column and then want to display it in the main column (example is the case for crop yields per sector, sector 1, sector 2, sector 3 have different crop yields in sequence, then I want to display the sum of the three sectors in one table) what are the proper formulas and features? Thank You. ---
**Author:** ![tommyrepi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tommyrepi/32/76354_2.png) [@tommyrepi](https://community.glideapps.com/u/tommyrepi)\ **Post date:** [June 10, 2024, 1:35am UTC](https://community.glideapps.com/t/sum-from-different-table/74000/2 "2024-06-10T01:35:30Z")
Like from table “Lembor” (same as “Pacar” and “Komodo”) ![Screenshot 2024-06-10 093507](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/785aac664c1b4372c787fe2a662700ad12c18d1d.jpeg) ---
**Author:** ![tommyrepi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tommyrepi/32/76354_2.png) [@tommyrepi](https://community.glideapps.com/u/tommyrepi)\ **Post date:** [June 10, 2024, 1:36am UTC](https://community.glideapps.com/t/sum-from-different-table/74000/3 "2024-06-10T01:36:08Z")
Into this table ![Screenshot 2024-06-10 093531](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f0c77ebdde61d82b02d29b9e9758d1432bdd02c5.jpeg) Thank you ---
**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:** [June 10, 2024, 2:51am UTC](https://community.glideapps.com/t/sum-from-different-table/74000/4 "2024-06-10T02:51:11Z")
Use a Rollup Column. > **[Rollup Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/rollup-column)** > > Perform calculations on columns, such as count, average, and sum. ---
**Author:** ![tommyrepi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tommyrepi/32/76354_2.png) [@tommyrepi](https://community.glideapps.com/u/tommyrepi)\ **Post date:** [June 10, 2024, 2:59am UTC](https://community.glideapps.com/t/sum-from-different-table/74000/5 "2024-06-10T02:59:56Z")
I’ve tried it, but only one sheet is taken, and adds up all the harvested areas in different commodities. ---
**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:** [June 10, 2024, 3:01am UTC](https://community.glideapps.com/t/sum-from-different-table/74000/6 "2024-06-10T03:01:50Z")
So you want to sum values from multiple sheets? Use a separate rollup column to sum the values in each sheet, and then a math column to add up all the sums. ---
**Author:** ![tommyrepi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tommyrepi/32/76354_2.png) [@tommyrepi](https://community.glideapps.com/u/tommyrepi)\ **Post date:** [June 10, 2024, 3:12am UTC](https://community.glideapps.com/t/sum-from-different-table/74000/7 "2024-06-10T03:12:28Z")
I still don’t understand. My goal is to display crop results, one of which is rice, the data for which is taken from sectors 1, 2, and 3. Because different rows, different types of plants. ---
**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:** [June 10, 2024, 3:23am UTC](https://community.glideapps.com/t/sum-from-different-table/74000/8 "2024-06-10T03:23:19Z")
Okay, I’m catching up and I think I understand. I think what you want is a series of multiple relation columns in your Hasil Panen table. Each should match the crop name with the same value in the other tables. Then you can do rollups through those relations. Does that get you what you are looking for? ---
**Author:** ![tommyrepi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tommyrepi/32/76354_2.png) [@tommyrepi](https://community.glideapps.com/u/tommyrepi)\ **Post date:** [June 10, 2024, 3:24am UTC](https://community.glideapps.com/t/sum-from-different-table/74000/9 "2024-06-10T03:24:43Z")
Yes, that is what exactly i mean. ---
**Author:** ![tommyrepi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tommyrepi/32/76354_2.png) [@tommyrepi](https://community.glideapps.com/u/tommyrepi)\ **Post date:** [June 10, 2024, 3:46am UTC](https://community.glideapps.com/t/sum-from-different-table/74000/10 "2024-06-10T03:46:44Z")
> [@Darren\_Murphy](#): > > Each should match the crop name with the same value in the other tables But i don’t understand how to do it. ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [June 10, 2024, 7:02am UTC](https://community.glideapps.com/t/sum-from-different-table/74000/11 "2024-06-10T07:02:23Z")
Maksud dari Darren adalah anda kumpulkan semua data dari berbagai lembar ke lembar “Hasil Panen” menggunakan kolom relasi, baru dilanjutkan untuk menghitungnya dengan rollup atau math. ---
**Author:** ![tommyrepi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tommyrepi/32/76354_2.png) [@tommyrepi](https://community.glideapps.com/u/tommyrepi)\ **Post date:** [June 11, 2024, 3:03am UTC](https://community.glideapps.com/t/sum-from-different-table/74000/12 "2024-06-11T03:03:32Z")
I see, thank you Mr. Himaladin and Mr. Darren ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [June 18, 2024, 3:03am UTC](https://community.glideapps.com/t/sum-from-different-table/74000/13 "2024-06-18T03:03:34Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.