How do I keep from repeating total on spreadsheet in excel.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I stop the running total from displaying on last entry. Example: B3+A4
will give me a WTD running total in B4. However B5, B6,B7 etc. displays B4
results. What must I do to keep this cells zeros or blank, until my next
entry?
 
In cell B4 instead of using = B3+A4 put =IF(A4="","",B3+A4) and copy it down.
This is assuming that you just manually enter a new number into Column A
each day.
This will look at cell A4. If it's empty B4 will remain empty. Once you
put a number
into cell A4, cell B4 will add B3 and A4 together. Hope that helps.
 

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

how to get totals? 1
Formula for subtracting from same number 5
How to stop running total on excel spreadsheet 2
Any math function on last 5 non zero or empty cells in a column 1
Copy/paste from many worksheets in the same spreadsheet into one r 2
Display Last Entry in Excel 6
Invert a column 5
Create error msg based on calculation result in formfield using VBA 1

Back
Top