1. =INDIRECT(A1&".C2") 2. How about =F4+SUM(E5:E500)-SUM(D5:D500) Blank or zero cells won't affect the total.
-- Dennis Disclaimer: The above is my opinion. I do not guarantee it. Be sure to back up any files involved and use at your own risk. Batteries not included. Not for internal use. Don't run with knives. "John R. Sowden" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Two application questions using OOo 2.0.0, under Suse 9.3 > > 1) I want to reference a sheet name based on the value of a cell: > a1="Sheet_Name" > formula: =_____(a1).c2 > ___ is the "missing function. > > 2) I have a ledger sheet with a balance column. I test to see if the > 'item' > column is blank so I don't run the balance all the way town to row 500, or > whatever. If the item is blank, I make the balance cell blank. > > Problem: I want to put the last balance at the top of the page. How do I > reference the last cell to have data, which is the ending balance? > > Balance Column formula: =if(c5="";"";f4-d5+e5) > c5=item, d is debit, e is credit f is the balance column > > Thanks, > > -- > John R. Sowden > AMERICAN SENTRY SYSTEMS, INC. > Residential & Commercial Alarm Service > UL Listed Central Station > Serving the San Francisco Bay Area Since 1967 > [EMAIL PROTECTED] > www.americansentry.net --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
