running total qustion

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I'm keeping a worksheet that computes running totals for day's receipts. It
totals amounts from cells a2:a5 and stores that total in cell a8. The next
day takes the total from a8 and adds the sum (b2:b5). And so on. My question
is, how can I make this running total column appear empty for days that have
yet to be entered?

TIA,

Jim
 
=IF(SUM(A2:A5)="","",SUM(A2:A5)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Back
Top