On Fri, 27 May 2005 17:14:20 -0400, George L. Minson wrote: > > >> >> >GregChi <[EMAIL PROTECTED]> skrev den Fri, 20 May 2005 15:46:01 -0400: >> > >> >> In a check register I want a formula in cell A1 to show the last >> >> value in the column(D?) that is the current balance. As more data is >> >> entered this last item will be shifted down. Until data is entered the >> >> cell is empty. >> >> Is there a function/formula for this? >> > >You can get what you want by reconstructing the last number in Column >D (your account balance) > >Add together: >The first active cell in column D (your balance forward) & >The sum of all the cells on the page in Column B (your deposits) >Subtract >The sum of all the cells on the page in Column C (your disbursements) > >Thus, the formula in Cell A1 would look something like > =D3+sum(B3:B200)-sum(C3:C200)
Thanks, that will work.. -- Greg Agent 1.93/32.576 Opera8 OOo 2(1979) news.readfreenews.net & news.gmane.org Win98se for sale: Apple//,Auto Parts/Equip/Manuals: http://[EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
