I just subscribed. The previous message did not show up for an hour so
I try again after I have been subscribed. Let's see! :-)
I set up an income statement that collects the data from the checking
account page. I don't know how many lines will be used in a month, so
I in order to collect the income statement data only for a particular
month using the sumif statement, I hard code the starting line and
ending line. Therefore I have edit this each month.
Instead, I would like to have a chart with start and stop lines in
separate cells, then have the formula refer to the chart on the same
page to see what the line number is. That was I only have to enter the
start and stop lines each month instead of editing about 75 cells.
Sample Chart:
MONTH START END
Jan 6 80
Feb 85 162
and so on...
Sample sumif formulas:
Hard coded: =sumif($checks.$M$85:$checks.$M$162,etc.
Cell Reference Method (cell referenced is in parenthesis):
=sumif($checks.$M$(b110):$checks.$M$(c110), etc.
Any ideas would be helpful,
John Sowden
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
