Yes, but you have to use the RNGMERGE() function in your formulas to build the necessary account-department ranges. From the Help:
=RNGMERGE()
Description
Use this function to create a list of all possible combinations of accounts and departments, where the accounts and departments are stored in separate cells. This function is most commonly used to aid in calculating a sum of non-consecutive accounts and/or departments in a single cell.
This function can be used in conjunction with the functions ADGET, ADDEBIT, ADCREDIT, ADCRONLY and ADDRONLY. For an illustration, see Example #2 below.
If we use RngMerge to refer to two cells, cells A1 and A2, where cell A1 = 1000:2000-, 3000:4000-, 5000-, and A2 = 100,250, the formula would be:
and the result would be:
1000:2000-100, 1000:2000-250, 3000:4000-100, 3000:4000-250, 5000-100, 5000-250
Example #2 This function:
ADGET (”gldata.M”, RngMerge(A1,A2))
will give you the current month net posted amount for the range of accounts shown in the example above.
You may need some assistance to get your first statement built.
Previous Topic
Index