sum up totals in lookup table

Many thanks to those that helped on my lookup question. I feel silly as it was an obvious mistake.

I need to make a program to take inventory at a bakery. We do this twice a day. Our products are loaves of bread. We have white, multigrain, soy and lindseed, low gi, and gluten free.

They are in pallets, trolleys, crates, boxes, pallet rows (part of a pallet) and individual loaves (singles)

I need to find out how many loaves that we have. How do I total them up?

unpack2.xlsx