antinora
Board Regular
- Joined
- Dec 4, 2013
- Messages
- 87
- Office Version
- 365
- 2016
- Platform
- Windows
Greetings:
Is there a way to total all the Reg cells for a unique name appearing in sheet below. For example: for each incident of T.Brown I was the cell immediately to the right totaled with all other incidences.
Ideally I'd select the entire worksheet and have it total all cells to the right of each unique name.
I'm trying not to have to massage the data too much.
Thanks,
JA
Is there a way to total all the Reg cells for a unique name appearing in sheet below. For example: for each incident of T.Brown I was the cell immediately to the right totaled with all other incidences.
Ideally I'd select the entire worksheet and have it total all cells to the right of each unique name.
I'm trying not to have to massage the data too much.
Thanks,
JA
Monday 7/18/22 | Reg | OT | Travel | Tuesday 7/19/22 | Reg | OT | Travel | Wednesday 7/20/22 | Reg | OT | Travel | Thursday 7/21/22 | Reg | OT | Travel | Friday 7/22/22 | Reg | OT | Travel | Saturday 7/23/22 | OT | Travel | Sunday 7/24/22 | DT | Travel | |
T.Brown | 8 | 3.5 | 7/19/2022 | 11-OPC (PLM) Inventory | 11-OPC (PLM) Inventory | 15- Vacant Inventory | 15-WPO Inventory | 11-OPC (PLM) Circuits | 15-WPO-Circuits | |||||||||||||||||
A. Skahill | 8 | 3.5 | 7/19/2022 | 11-Lab Test Intl (Intertek) Inventory | 11-Lab Test Intl (Intertek) Inventory | 15-WPO Inventory | 13-Tanenbaum Inventory | 15-WPO-Circuits | 11-Lab Test Intl (Intertek) Circuits | |||||||||||||||||
7/19/2022 | T.Brown | 8 | T.Brown | 8 | T.Brown | 8 | 0.5 | T.Brown | 8 | 1.5 | T.Brown | 8 | 10-Vacant/Hello Fresh Rcpt Circuits | |||||||||||||
7/19/2022 | A. Skahill | 8 | H.Hartog | 8 | 4 | H.Hartog | 8 | 1.5 | H.Hartog | 8 | 1.5 | H.Hartog | 8 | T.Brown | 4.5 | |||||||||||
7/19/2022 | M.Dietz | 8 | M.Dietz | 8 | M.Dietz | 8 | A. Skahill | 8 | H.Hartog | 5 | ||||||||||||||||
7/19/2022 | C.Osorio | 8 | C.Osorio | 8 | C.Osorio | 8 | A. Skahill | 4.5 | ||||||||||||||||||
7/19/2022 | A. Skahill | 8 | A. Skahill | 8 | 1 | A. Skahill | 8 | 1.5 | ||||||||||||||||||
Monday 7/25/22 | Reg | OT | Travel | Tuesday 7/26/22 | Reg | OT | Travel | Wednesday 7/27/22 | Reg | OT | Travel | Thursday 7/28/22 | Reg | OT | Travel | Friday 7/29/22 | Reg | OT | Travel | Saturday 7/30/22 | OT | Travel | Sunday 7/31/22 | DT | Travel | |
13-Tanenbaum Inventory | 13-Tanenbaum Troubleshoot | 13-Tanenbaum Troubleshoot | 12-DB Schenker Inventory | 12-DB Schenker Inventory | 13-Tanenbaum Circuits | 13-Tanenbaum Circuits | ||||||||||||||||||||
T.Brown | 8 | 1 | T.Brown | 8 | 1 | T.Brown | 8 | 1 | T.Brown | 8 | 1 | 16-18 GSA Fr. Elev Troubleshooting | 12-DB Schenker Circuits | 12-DB Schenker Circuits | ||||||||||||
H.Hartog | 8 | 1 | H.Hartog | 8 | 2.5 | H.Hartog | 8 | 1 | H.Hartog | 8 | 1 | T.Brown | 8 | 3.5 | H.Hartog | 6 | 11-Lobby Circuits | |||||||||
M.Dietz | 8 | M.Dietz | 8 | M.Dietz | 8 | M.Dietz | 8 | H.Hartog | 8 | 0.5 | C.Osorio | 5 | A.Sundeen | 8.5 | ||||||||||||
C.Osorio | 8 | C.Osorio | 6 | C.Osorio | 8 | C.Osorio | 8 | M.Dietz | 8 | A. Skahill | 6 | H.Hartog | 5 | |||||||||||||
A. Skahill | 8 | 5 | A. Skahill | 3 | A. Skahill | 4 | A. Skahill | 6 | C.Osorio | 8 | A. Skahill | 5 | ||||||||||||||
A. Skahill | 8 | 2 |