We have a production summary report that needs to keep a daily count of what was produced on each job.
The excel sheet has a column with the number of pieces produced today, and a column with the total number of pieces produced. We want to be able to enter the number produced today in the number of pieces produced today cell, and have that update the total pieces cell with a running sum.
Example:
Monday's entry would be:
A B C
1 Job# Total Daily Total Count
2 12163 1,000 1,000
Tuesday's entry would be:
A B C
1 Job# Total Daily Total Count
2 12163 2,000 3,000
Would would like to enter the data into the same cell every day and automatically accumulate the running total.
The excel sheet has a column with the number of pieces produced today, and a column with the total number of pieces produced. We want to be able to enter the number produced today in the number of pieces produced today cell, and have that update the total pieces cell with a running sum.
Example:
Monday's entry would be:
A B C
1 Job# Total Daily Total Count
2 12163 1,000 1,000
Tuesday's entry would be:
A B C
1 Job# Total Daily Total Count
2 12163 2,000 3,000
Would would like to enter the data into the same cell every day and automatically accumulate the running total.