In fact I don't really know what does "gen led account" and "gl account" (i guess they are the same thing... either way, I don't know what is it).
Another way to do it is with cell range names. For example, imagine the January range you want to sum is from N1:N18, and the february range is from N75:N348. You could select the first range, then go to Insert/Names/Define menu, put a name for the range in the opened window, then accept it. And do the same for all the range names you want to define. For example "janCalculation", "febCalculation" and so on. Then you can simply put a formula like: "=sum(janCalculation;febCalculation)" for example. It's possible to change the ranges later on... and your formula will still work properly, as long as the names used in it, are still defined. Or even you can put a name to a single cell value, if you like. Well... I hope it helps. Ely. 2009/4/11 John R. Sowden <[email protected]> > I have a accounting journal broken by months with totals per > month. I want to create a report by gen led account per > month. > > The starting and ending lines per month vary, so I set up a > chart: > > Jan start > Jan end > Feb Start > Feb End > with the line number in each cell. I want to put these values > into the formula which sums the amounts per gl account, > within these 2 line numbers. How do I get the value in the > cell to be part of the =sum(month.start:month.end) formula. > > tia. john > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
