Freezing an auto update field
 

Hi all,


I've set up a spreadsheet to update from a formula. The spreadsheet is
designed to track monthly information and does that well, but the
formula is allowing(causing?) these cells to change even after that
month is passed.
i.e:

Jan = $275
Feb = $325
Mar = $300
Apr = $450

Total = $1,350

With the formula setup, after a certain total is reached, Jan ='s $315,
Feb = $364... I want the totals to remain static after they are figured
and not to adjust as changes are made later.

Does anyone know of an easy way to accomplish this?

TIA,

Byron