Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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. "Keeping it clean" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Applying Existing Password to New Spreadsheet | Excel Discussion (Misc queries) | |||
Can I total information in 1 spreadsheet from several others? | New Users to Excel | |||
Total remaining formula | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |