I added two accounts and I was able to add them into the income statement without a problem. But, I can't figure out how to include them in the sum for "income before income taxes". It is only taking the number for "operating income (loss) which is in cell "E88" but the formula shows "=-SUM(-SUM(Acc_T151),-SUM(Acc_T171)). can you tell me how to fix this? The added account numbers are 5310 and 5320 and they are in cells "e93" and "e94" respectively. Thanks for your help/

You are using a "converted" specification. Although these generally work they are dificult to modify and were meant to get you started when coming from the DOS world.

I suggest that you clean up your statement following the rules outline in:

http://www.softrak.com/cgi-bin/ultimatebb.cgi?ubb=get_topic&f=1&t=001548

or having your dealer make the required changes.

Once you do this I believe you will have an easier time making the changes to add your two new accounts.

There is also a FX seminar scheduled that would help you with designing/changing Financial Statements.

See:

http://www.softrak.com/webinars/

Hi Sherri,

Also to clarify, that "-SUM(Acc_T171)" and similar formula syntax is coming from the converted specification and would never be necessary when editing or creating financial statements with Adagio.

To add cell values together, you can do any of the following:

=e93+e94 (to add two cells together)
=sum(e93..e97) (to add a range of cells in a column)
=sum(e93..j93) (to add a range of cells in a row)
=sum(e93, e97, e102) (to add specific cells together)

If you are still having problems, post here what cells you are wanting to add together and the formula you are using to try and create the sum.