Thread: zero out
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pieter[_3_] Pieter[_3_] is offline
external usenet poster
 
Posts: 1
Default zero out

I am only a beginner so could you please keep it simple.
I need to build a spreadsheet for weekly reporting.
I need one column for "number installed to date".
I need another column for "number installed this period" which will add onto the "number installed to date".
Every week I will have to zero out the "number installed this period column", without changing the values in the "number installed to date" column.
Once zeroed, I need to enter new figures for the week, which ideally would add themselves to "number installed to date".
Any help would be much appreciated.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com