# Importrange in glide tables using excel formula **URL:** \ **Category:** Ask for Help\ **Created:** [December 20, 2023, 8:19am UTC](https://community.glideapps.com/t/importrange-in-glide-tables-using-excel-formula/68864 "2023-12-20T08:19:26Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [December 20, 2023, 8:19am UTC](https://community.glideapps.com/t/importrange-in-glide-tables-using-excel-formula/68864/1 "2023-12-20T08:19:26Z")
How can I perfom an importrange, unique formula from another glide table using excel formula so that I summerize the values for statistical analysis… ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [December 20, 2023, 6:37pm UTC](https://community.glideapps.com/t/importrange-in-glide-tables-using-excel-formula/68864/2 "2023-12-20T18:37:01Z")
I think importrange() will work between sheets of the same spreadsheet in Google Sheets, but not between Google Sheets and Glide Tables. To import data into a Glide Table from a Google Sheets, I think a CSV import would work well (one time). In a Glide Table you can use the `relation`, `lookup` and `query` columns to look up data from another Glide Table. ---
**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\ **Post date:** [December 20, 2023, 6:56pm UTC](https://community.glideapps.com/t/importrange-in-glide-tables-using-excel-formula/68864/3 "2023-12-20T18:56:21Z")
Ok, thnak you so much. I have a glide table in which data is added through form submissions. How ever to do some calculations and summaries of the data, I want to bring the key unique values into a column then make a relation , looking up the other information and do some summary calculation on it using roll up columns. The summaries will now be for specific months or something like that. so the last option you suggested ideal. Any examplt of how to do this? ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [December 20, 2023, 7:10pm UTC](https://community.glideapps.com/t/importrange-in-glide-tables-using-excel-formula/68864/4 "2023-12-20T19:10:15Z")
Let’s say you have a Glide Table of sales data and you would like to determine sums by month. You would then create a separated Glide Table called Monthly Sales Report, create 12 rows for 12 months (January, February, … , December), create a `relation` or `query` column to point each month to the associated rows in the Sales table, and finally you would create a `rollup` column and configure it to sum. This thread on the query column could come in handy. > [@magnet The QUERY Column: One Column to Rule Them All!](https://community.glideapps.com/t/the-query-column-one-column-to-rule-them-all/61532): > > wave Hey fellow Gliders! mechanical_arm Glide just got even more powerful by introducing the QUERY column! No more complex, multi-column setup to achieve conditional relations. The Query column can: point_right Filter point_right Sort AND point_right Limit related data in ONE COLUMN Learn more: [[Glide 101: Query Column Replaces DOZENS of Computed Columns] ](https://www.youtube.com/watch?v=2K3KzgbrXT8) ---
**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:** [December 20, 2023, 7:16pm UTC](https://community.glideapps.com/t/importrange-in-glide-tables-using-excel-formula/68864/5 "2023-12-20T19:16:21Z")
Ya…query works well. here’s another video that might help: > [@litter\_in\_bin\_sign Trash your Excel Formulas](https://community.glideapps.com/t/trash-your-excel-formulas/55788): > > wave Hey Gliders! By request, I created a video that explains how to replace 14 commonly used Google Sheet/Excel Formulas using Glide computed columns and other native Glide functionality. Formulas are timestamped in the description. For good measure, I also threw in how to use the Excel Formula plugin column upside_down_facepopcorn Enjoy! [[Glide: Replace 14 Excel Formulas with Glide Computed Columns] ](https://www.youtube.com/watch?v=YITKadLUKNE)