Sum multiple values using Lookups

[FinPro]

I have sheet as below where "Items" in col A exists in multiple warehouse Col B and there value shown in Col D. I need a formula on another sheet to sum "Item value" irrespective of Warehouse. Vlookup or Index stops on first instance and ignores the rest of the table.

Item	WH	Inv. On Hand	Inv Value
1100117240	110-01	175062.9	159,132.16
1100117253	110-01	10158.29	9,233.88
1100117265	110-01	350767.9	352,135.86
1100117265	120-01	13875.62	13,929.73
1100120240	110-01	564893.4	513,488.11
1100120240	120-01	221941	201,744.37
1100125230	110-01	1358918	1,183,889.61
1100125230	120-01	6027.128	5,250.83
1100125256	110-01	19736.53	15,728.03
1100700249	120-01	208793.9	161,857.03
1100700256	110-01	224316.4	178,757.73
1100700256	120-01	14688.8	11,705.50

<tbody>
</tbody>

Thanks in advance for your help.

 

[steve the fish]

The function you need is SUMIF. Your range column A. Your criteria the item number. Your sum range column D.