[libreoffice-users] Calc: Cell Reference Duplicate?

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: users+help@global.libreoffice.org
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