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.

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

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.