I am trying to set up reports based on the samples supplied with the G/L.

In the income statement #4, the data is selected based on the information in column A.

If you want to draw data from a number of accounts, how do you format the information in column A so the data is totalled?

For example, I have three revenue accounts, 400, 406 and 495. I want the total of these three accounts to appear in one cell. I have tried inserting commas between the account numbers and that doesn't work.

Hi bal,

Do you use Departments for your revenue accounts? This would make a little difference as to the answer, but not too much.

If you don't use departments, the syntax for the cell in column A is simply the accounts, separated by commas. In your case: "400, 406, 495". You don't have to include the double-quotes as the commas will automatically identify this cell as text, which is required for cell referencing of accounts.

If you do use departments, and use the syntax above for your cell in column A, this is correct syntax, but will only sum these accounts and BLANK departments. Presumably you don't use blank departments, so the result will be zero.

The correct syntax would be to include a dash and a backwards apostrophe after each account, and still separate each with commas. The backwards apostrophe is located to the left of the 1 key at the top left of most keyboards. Therefore, you would use:

"400-`, 406-`, 495-`"

The purpose of the bakcwards apostrophe is that this is a reserved character, and will automatically be replaced by the value found in the Department Dropdown field on the Toolbar. If this is a consolidated statement (ie all departments), then the ` will be replaced with the * wildcard instead of a specific department.

Regards,