0

G/L account balance for multiple accounts in range

Sandeep Kuntam

January 15, 2020 21:58

None

Follow

Hello, 

 

I have a unique problem and will need to see if anyone here can point me to a solution. 

I need to have balance on multiple GL accounts in one line which are not exactly in a range but are in a smaller range of their own. 

for example from Fabrikam company I would need to get balance of these GL's in one line. notice I will need to use wildcards and ranges. 

=GL("Cell","Balance",000-1300-01|0001300-02|000-1330-*|000-1350-02..08)

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Bryan Robinson May 08, 2020 13:21

  Using your example, you need to specify the full account number when dealing with the range:

  =GL("Cell","Balance",000-1300-01|000-1300-02|000-1330-*|000-1350-02..000-1350-08)

  The formula as it stands in your post says accounts between account "000-1350-02" and account "08".

• 0
  
  Sandeep Kuntam May 08, 2020 16:07

  Thanks Bryan, I will try this and let you know how it goes.