How to total sum of non-numerical values in a cell

[jdogg29]

how can I take the values from the table on the right and total them up at the bottom of the weekly tally on the left?

So say there is a weekend (worth 12 hours), four "day" shifts (worth 8 hours each) and two off shifts (worth 0 hours each) and get the total sum at the bottom of each week, so for this one it will be 44?

[#2]

@jdogg29 

Perhaps this:

=SUM(XLOOKUP(C1:C5,H1:H8,I1:I8))

[#3]

@Patrick2788 

Wow thanks for the super quick response. That works for the one row, but if I copy it down it doesn't work for the other rows totals, like this

how can I get all the other "sum" rows to work with the same table on the right?

[#4]

@jdogg29 

Lock in the ranges:

=SUM(XLOOKUP(C1:C5,$H$1:$H$8,$I$1:$I$8,0))

[#5]

It still comes up with #N/A, am I doing something wrong?

[#6]

I didn't realize there were some blanks in the range that would cause an error with the XLOOKUP. I've revised my previous post.