I am new to the forum... Hello!
I am not sure if it is possible, but with the help of your collective expertise, hopefully we can find a solution to my issue.
We are trying to simply Sum a column, but the cells will contain Text and Numbers mixed.
We were hoping to either:
1/ Be able to select a portion of this alphanumeric text in a cell to 'ignore', while leaving a single number to Sum within the column
or
2/ Specify one of the numbers within the alphanumeric text to be the only number to sum within a cell.
The Scenario:
This is for our Production Schedule (manufacturing), where our Labor allocation (number of workers) needs to be accounted for at all times
Our different Production Lines/Machines are represented in the Rows of the spreadsheet, and the Time is represented in the Columns (each column is a half hour increment).
We 'paint' in the duration of the different jobs left to right, and have a specific format we use to identify the job details: "CUSTOMER-ITEM#-PURCHASEORDER#-#OFWORKERS"
Example of the format would be: ABCCOMPANY-08888-18500-7
What I was hoping to do to make things easier, is to sum each 30min column throughout the day, to only count the Number of Workers to ensure they are all allocated at all times of the day.
In other words, using the example above, is is possible to select a certain part of the text to ignore, to leave only a number to Sum in the column (the 7 workers in this case):
ABCCOMPANY-08888-18500-7
Or alternatively, and I specify one value to be the only one to Sum in the column? ABCCOMPANY-08888-18500-7
Thank you in advance
I am not sure if it is possible, but with the help of your collective expertise, hopefully we can find a solution to my issue.
We are trying to simply Sum a column, but the cells will contain Text and Numbers mixed.
We were hoping to either:
1/ Be able to select a portion of this alphanumeric text in a cell to 'ignore', while leaving a single number to Sum within the column
or
2/ Specify one of the numbers within the alphanumeric text to be the only number to sum within a cell.
The Scenario:
This is for our Production Schedule (manufacturing), where our Labor allocation (number of workers) needs to be accounted for at all times
Our different Production Lines/Machines are represented in the Rows of the spreadsheet, and the Time is represented in the Columns (each column is a half hour increment).
We 'paint' in the duration of the different jobs left to right, and have a specific format we use to identify the job details: "CUSTOMER-ITEM#-PURCHASEORDER#-#OFWORKERS"
Example of the format would be: ABCCOMPANY-08888-18500-7
What I was hoping to do to make things easier, is to sum each 30min column throughout the day, to only count the Number of Workers to ensure they are all allocated at all times of the day.
In other words, using the example above, is is possible to select a certain part of the text to ignore, to leave only a number to Sum in the column (the 7 workers in this case):
ABCCOMPANY-08888-18500-7
Or alternatively, and I specify one value to be the only one to Sum in the column? ABCCOMPANY-08888-18500-7
Thank you in advance
