LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
james9662
 
Posts: n/a
Default 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
 
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
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
Pivot table for reporting sales performance Ram Excel Discussion (Misc queries) 2 February 6th 06 10:06 AM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
In excel - how to total column if am not sure of the last cell PFHMoney New Users to Excel 4 May 27th 05 01:27 PM
How do I reference every "n" cell in a column in Excel? Alma Excel Worksheet Functions 2 March 22nd 05 06:19 PM


All times are GMT +1. The time now is 11:58 PM.

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

About Us

"It's about Microsoft Excel"