mibuso.com

I have an account schedule formula row that needs to total 400 lines. Is there an easier way create a summary instead of entering 1+2+3+4+5+...... I tried to enter 1..400 however this returns an error message when printing the account schedule. Any help is appreciated as this type of data entry is mind numbing.

Hi Witty,

the formula can also do ranges. The problem is that you can encounter cyclic references with this. Usually it's a good idea to give Row Nos to every Account Schedule Line, all with the same length (Row No. is a code field). If you already have totaling lines in the Acc. Schedule, I would suggest to give them a distinct range. This way you can easily specify a totaling range for the "base" lines, or for the totaling lines (depends on what is more apropriate).

with best regards

Jens

I was able to sum lines 1-400 by giving each line the same row number of "REV" then entering "REV" in the totaling line. This summarized all lines. Thanks for the quick help.