Hi Karen,

Thanks for the information. To interpret the formula and the layout:

Cell D7 will contain the field you want to report on, 'BAL' or the current balance as of the selected period on the toolbar.
Cell B9 contains the account code(s).
Cell D5 contains the department code(s).

The formula will connect all the account(s) and department(s) and sum each of their current balances, and report this (sum) in the cell.

When the report is summarized or 'Collapsed', you will see the range of accounts summed together, rather than the details. If you click the 'down arrow' key on the toolbar to 'Expand' the report (or show the details), then all of the rows that had .Range in column A will generate rows for individual accounts.

Ensure that you have a specific department in each of the cells on row 5. If you see a star *, this means all departments summed together. You can over-type a value in row 5 with a desired department, and then F9 on the keyboard to refresh.

If you selected the 'All departments' option when creating the sheet, you may find that the wrong amounts initially appear. Just press F9 and the amounts will re-calculate correctly.

If you double-click on a cell, you can drill-down to the accounts-departments that sum to the displayed amount in the cell (for most cells that have a GLAMT formula). Perhaps this could be useful to track down what is happening.