K
Kent
Short answer is "nope"
Formulas are usually designed for re-calculating changes
in a cell and forgetting "the old stuff". You can design
around this a bit with macro code or by hiding what you're
really doing and commuting the numbers somewhere else. It
all really depends on the design of what you have now to
determine best functionality.
Excel Support Technician
www.canhelpyou.com
-----------------------------------------------------------
-----------
Every member of the CanHelpYou team holds at least a
Microsoft Level 1 Excel certification. In addition, we
have experts in PowerPoint, Word and other products such
as IIS, SQL Server 2000, network connectivity.
manually into B1 and calculated to C1; the following month
February's totals will be manually put into B1 - I need C1
to remember January's total and add that to February's
total. Is this possible??
Formulas are usually designed for re-calculating changes
in a cell and forgetting "the old stuff". You can design
around this a bit with macro code or by hiding what you're
really doing and commuting the numbers somewhere else. It
all really depends on the design of what you have now to
determine best functionality.
Excel Support Technician
www.canhelpyou.com
-----------------------------------------------------------
-----------
Every member of the CanHelpYou team holds at least a
Microsoft Level 1 Excel certification. In addition, we
have experts in PowerPoint, Word and other products such
as IIS, SQL Server 2000, network connectivity.
changing totals in b1... January totals will be put in
manually into B1 and calculated to C1; the following month
February's totals will be manually put into B1 - I need C1
to remember January's total and add that to February's
total. Is this possible??