Hello mrExcel users!
I am JST013 and I am stumped...
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
This is what I am currently dealing with..
Date, operator, shift, machine number, machine speed, up time , goal, uptime goal and produced are my columns..
If i wanted to make a formula to seach through column B (operators) and return a value found in any of the other columns, Up time for example, and sum the results...how could I do this?
so lets say my operator is Adriana Silva, and I want to know the total of her up-time...
How can I total just her uptime?
Thank you so much!
I am JST013 and I am stumped...
Date | Operator Name | Shift | Machine Number | Machine Speed | Up-Time | Actual Goal | Up time Goal | Produced |
3/2/2015 | Adriana Silva | 1st | XX-01 | 20 | 320 | 7,680 | 6,400 | |
3/2/2015 | Andrew Gonzales | 1st | XX-02 | 20 | 320 | 7,680 | 6,400 | |
3/2/2015 | Augustina Flores | 1st | XX-03 | 20 | 320 | 7,680 | 6,400 | |
3/3/2015 | Adriana Silva | 1st | XX-01 | 20 | 120 | 7,680 | 2,400 | |
3/3/2015 | Andrew Gonzales | 1st | XX-02 | 20 | 120 | 7,680 | 2,400 | |
3/3/2015 | Augustina Flores | 1st | XX-03 | 20 | 120 | 7,680 | 2,400 | |
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
This is what I am currently dealing with..
Date, operator, shift, machine number, machine speed, up time , goal, uptime goal and produced are my columns..
If i wanted to make a formula to seach through column B (operators) and return a value found in any of the other columns, Up time for example, and sum the results...how could I do this?
so lets say my operator is Adriana Silva, and I want to know the total of her up-time...
How can I total just her uptime?
Thank you so much!