SUM of VLOOKUP results

Support
1

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?

2

Hi,

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.

3

this works! thanks~