On 02/26/2013 01:19 PM, John R. Sowden wrote:
I create a lot of ledger spreadsheets, including date,doc
no,item,debit,credit,balance,notes.
I have a formula in the balance column that tests for data in the item
column to show the balance otherwise I put a space there
[=if(c23="";"";g22+d23-e23)], so the balance does not display down the
page.
That said, I am trying to figure out how to put the last amount (not
space) in the balance column in a formula to display the balance at
the top of the screen, refer to it in a consolidated sheet, etc.
tia,
John
John
I assume you have a set of consolidated data cells. I would try
=sum(balance range).
--
Jay Lozier
[email protected]
--
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
