How to create a constant total column in Excel?
I am at a cabinet building company and we are needing to incorporate an
on-going column of accumulative totals, and they stay constant even when
other formulas that change the totals are changed or the other values
pointing to the totals are changed. I guess you could call it a column of
constant totals.
This is so that we can always see the accumulative total of cabinet parts
and we use other worksheets to change the totals to what they are and we'll
have other output sheets showing cabinet parts needed for a set of cabinets.
And when 1 job is done, we want to delete those entries and start another
job, but the totals stay constant from the last job session.
Help,
Jim
|