HickorySticks
New Member
- Joined
- Jul 8, 2023
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi all,
Hopefully, someone can point me in the right direction on this. I want to be able to sum the rows in the example below where whenever a certain text is entered into one of the cells the corresponding numerical value is pulled from the table from the far right of the sheet. I don't want the text to be replaced by the numerical value, I just want the sum of the row to reflect the values of the text along with the actual numbers in the row. There are more options in the table, but I streamlined it a bit for posting. Thanks in advance.
Hopefully, someone can point me in the right direction on this. I want to be able to sum the rows in the example below where whenever a certain text is entered into one of the cells the corresponding numerical value is pulled from the table from the far right of the sheet. I don't want the text to be replaced by the numerical value, I just want the sum of the row to reflect the values of the text along with the actual numbers in the row. There are more options in the table, but I streamlined it a bit for posting. Thanks in advance.
Time Log - Sample.xlsm | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | ||||||||||||||
2 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Total Hours | ||||||
3 | Birthday | 8 | ||||||||||||
4 | Douglas S. | 4.50 | 10.75 | Vacation | Birthday | 12.00 | 8.50 | Non Scheduled | 35.75 | Call Off | 0 | |||
5 | Robert J. | Off | 8.75 | 8.00 | 6.50 | 11.25 | 10.00 | Non Scheduled | 44.50 | Holiday | 8 | |||
6 | Tom M. | Off | 8.00 | 10.50 | 8.00 | 8.00 | 9.75 | Non Scheduled | 44.25 | Non Scheduled | 0 | |||
7 | Willie P. | Off | 10.00 | 7.50 | 8.50 | 8.00 | 10.00 | Non Scheduled | 44.00 | Off | 0 | |||
8 | Gene S. | 8.25 | 12.00 | Call Off | 8.00 | 8.00 | 8.00 | Non Scheduled | 44.25 | Vacation | 8 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I4:I8 | I4 | =SUM(B4:H4) |