Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Keeping it clean
 
Posts: n/a
Default How do I keep from repeating total on spreadsheet in excel.

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?
  #2   Report Post  
ww
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Data Using Multiple Worksheets to Total into a Grand Total Lillie Excel Worksheet Functions 1 April 19th 05 08:34 PM
Applying Existing Password to New Spreadsheet Vic Excel Discussion (Misc queries) 1 January 27th 05 12:37 AM
Can I total information in 1 spreadsheet from several others? Excel Novice New Users to Excel 3 January 7th 05 02:27 PM
Total remaining formula jbsand1001 Excel Worksheet Functions 2 January 6th 05 04:17 PM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"