Time log: Sum a row with both numbers and text

[HickorySticks]

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.

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)

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SUM(B4:H4,XLOOKUP(B4:H4,$K$3:$K$8,$L$3:$L$8,0))

 

[HickorySticks]

That seems to have done the trick. Thank you much!

 

[Fluff]

You're welcome & thanks for the feedback.