View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CMS CMS is offline
external usenet poster
 
Posts: 3
Default Making a budget with excel, keep a running total

I am trying to put together a budget which will keep a running total. For
example, if I have, say $100/month allocated for food, I want every time I
type in the month's total, for it to add the difference and keep a running
total. Say this month I spend $84, next month $105. I want the cell to
calculate "+11.00." I can do that, but I need to account for the months in
the future which are now blank.

The way I'm doing it (=SUM((100-C13)+(100-C14)+etc.) will assume for the
months that are blank (i.e. the future) I have spent $0.00 on food.

What function do I need? Thanks.
--
CMS