Hi Sandra,

To sum a group of non-consecutive departments, there is a function called RngMerge that can be used to build the appropriate account key for you. There are more thorough examples in the Help file for how to do this, but generally:

- Put the accounts in some cell (say A12)
- Put the departments in some cell (say D4)
- Each acct/dept should be separated by commas (for example: '100, 300, 500)
- Use RngMerge to build all the acct-dept combinations
RngMerge(A12,D4)
- Use this in a formula to get the amount (say for YTD net changes)
=ADGET("gldata.Y",RngMerge(A12,D4))

If you used the Departmental Comparative function, you could also see an example of the RngMerge function in use. Also, version 8.0B of Adagio Ledger allows you to create a sum of selected departments when creating a 'Departmental Comparative' statement.