# Importrange in glide tables using excel formula

**URL:** <https://community.glideapps.com/t/importrange-in-glide-tables-using-excel-formula/68864>\
**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:** 1\
**Showing post:** 4

<div class="post-metadata">

**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")

</div>

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)

---

_[View the full topic](https://community.glideapps.com/t/importrange-in-glide-tables-using-excel-formula/68864)._