SUM of VLOOKUP results


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?


You could try SUMIF().
For instance, SUMIF(D10,‘Transportation’,H10) that will return the sum of the values in subtable column H10, when subtable field value D10 is Transportation.

this works! thanks~