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

Occasional Contributor

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

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?

5 Replies

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

Perhaps this:

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

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

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?

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

Lock in the ranges:

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

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

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

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

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.