Hi

Is there any way for me to get the SUM of VLOOKUP results from a subtable?

I try using the formula like SUM(VLOOKUP(“Transportation”, D10, H10, true, true)) , but this formula always display the first value it finds from the subtable instead of the total. So, am I doing the right way?