View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PeterAtherton PeterAtherton is offline
external usenet poster
 
Posts: 42
Default Another checkbook registry problem...

Try this, it works if you delete rows later, and shows zero if there is no
date in column A

=IF(ISBLANK(A2),0,SUM($B$2:B2)-SUM($C$2:C2))

Regards
Peter
"LJB Jazz" wrote:

I am trying to put together a checkbook registry much like the Excel
Checkbook Registry Template, and I know how to make the columns/ rows a
certain function (i.e. currency, date, etc.) but I can't figure out the
formula to get the running balance. If someone could help, i would greatly
appreciate it!

Jazz
P.S. I'm using MS Excel 2003.