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

Question

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?

patrick2788 · Answer

jdogg29&nbsp;&nbsp;Perhaps this:=SUM(XLOOKUP(C1:C5,H1:H8,I1:I8))

patrick2788 · Answer

jdogg29&nbsp;Lock in the ranges:=SUM(XLOOKUP(C1:C5,$H$1:$H$8,$I$1:$I$8,0))&nbsp;&nbsp;

jdogg29 · Answer

Patrick2788&nbsp;&nbsp;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&nbsp;&nbsp;how can I get all the other "sum" rows to work with the same table on the right?

jdogg29 · Answer

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

patrick2788 · Answer

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.

Forum Discussion

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

Share

Resources