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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum a license total, then vlookup to determine training cost 11
Formula Query 9
How to set cell value to emptry if three other columns are empty too 1
Getting a cell to update totals automatically every day 3
Excel or microsoft works spreadsheet question 2
Putting text into a cell 1
Changing cell color with a formula? 3
How to stop running total on excel spreadsheet 2

Back
Top