# GL Account Ranges within SI.QUERYFILTER

**URL:** <https://community.velixo.com/t/gl-account-ranges-within-si-queryfilter/72>\
**Category:** Q&A\
**Tags:** Sage-Intacct\
**Created:** [September 5, 2024, 8:34pm UTC](https://community.velixo.com/t/gl-account-ranges-within-si-queryfilter/72 "2024-09-05T20:34:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nathan\_Gayeski](https://community.velixo.com/letter_avatar_proxy/v4/letter/n/3be4f8/32.png) [@Nathan\_Gayeski](https://community.velixo.com/u/Nathan_Gayeski)\
**Post date:** [September 5, 2024, 8:34pm UTC](https://community.velixo.com/t/gl-account-ranges-within-si-queryfilter/72/1 "2024-09-05T20:34:47Z")

</div>

Hello, I would like to know if we can multiple ranges within a SI.QUERYFILTER? I understand we can have a range of 2000 to 3999. However, I would like to have a range of 2000 to 2500 and also a range of 3000 to 3200. Is that possible?

Alternatively, could we have a selection of accounts? Example 3001, 3002, 3110, 3200, etc.?

 ![Screenshot 2024-09-05 143305.png](https://community.velixo.com/uploads/default/original/1X/0b0087aa09734f493ff144ba2d7047ad0305795e.png)  
 ![Screenshot 2024-09-05 083858.png](https://community.velixo.com/uploads/default/original/1X/667769213b36df3e1147e120f36f95460e04de4c.png)

---

<div class="post-metadata">

**Author:** ![Gabriel](https://community.velixo.com/user_avatar/community.velixo.com/gabriel/32/7_2.png) [@Gabriel](https://community.velixo.com/u/Gabriel)\
**Post date:** [September 6, 2024, 7:01pm UTC](https://community.velixo.com/t/gl-account-ranges-within-si-queryfilter/72/2 "2024-09-06T19:01:31Z")

</div>

Hi Nathan,

The trick is to use SI.EXPANDACCOUNTRANGE() to transform your account range into a format that SI.QUERYFILTER can understand:

=SI.QUERYFILTER(“Sage”,“GLDETAIL”,“ACCOUNTNO”,SI.EXPANDACCOUNTRANGE(“Sage”,“2000:2500;3000:3200”))

_(note: you will obviously not want to hardcode the accounts in the formula, but reference a cell!)_

If you put SI.EXPANDACCOUNTRANGE() in its own cell you’ll see that it returns multiple cells - it’s what Excel calls a “dynamic array function”. The range syntax you can use is the same as all our other financial functions – see here for reference: [https://help.velixo.com/support/solutions/articles/153000012270-filtering-techniques-for-use-with-many-velixo-functions](https://help.velixo.com/support/solutions/articles/153000012270-filtering-techniques-for-use-with-many-velixo-functions)

Note that this should be used for a reasonably-sized range; the query could become too long otherwise. If you need just a from/to range the technique you used with \>= and \<= will work better.

---

<div class="post-metadata">

**Author:** ![Markens\_Juste](https://community.velixo.com/letter_avatar_proxy/v4/letter/m/ea666f/32.png) [@Markens\_Juste](https://community.velixo.com/u/Markens_Juste)\
**Post date:** [September 6, 2024, 7:20pm UTC](https://community.velixo.com/t/gl-account-ranges-within-si-queryfilter/72/3 "2024-09-06T19:20:49Z")

</div>

Hi Nathan,

Thank you for contacting Velixo Support.

Yes, it is possible. We have this article that shows many possible combinations: [Filtering techniques for use with many Velixo functions : Velixo for Sage Intacct Help](https://helpintacct.velixo.com/support/solutions/articles/153000012270-filtering-techniques-for-use-with-many-velixo-functions)

When you mention if it is possible to have a selection of accounts, are you referring to a drop-down list?

---

<div class="post-metadata">

**Author:** ![Nathan\_Gayeski](https://community.velixo.com/letter_avatar_proxy/v4/letter/n/3be4f8/32.png) [@Nathan\_Gayeski](https://community.velixo.com/u/Nathan_Gayeski)\
**Post date:** [September 6, 2024, 7:38pm UTC](https://community.velixo.com/t/gl-account-ranges-within-si-queryfilter/72/4 "2024-09-06T19:38:53Z")

</div>

Thank you both! I will test that out now.