I am trying to build a formula for inventory, storage values. one worksheet to another

[smithtronics]

I have attached a workbook with two worksheets as my sample

I want to use the storage worksheet for the Base Values, that will be input into the Totals worksheet.

[smithtronics]

I use these formulas in various iterations:
"=VLOOKUP($G350,$K:$L,2,FALSE)"
"='Facilities-Productions'!"SUMPRODUCT(($G$2:$G$9153="Blush")*($F$2:$F$6153))"
"=SUMPRODUCT(($C$2:$C$6153="Sink and Faucet Set")*($F$2:$F$6153))"
"=INDEX($AI$1:$AI$13,MATCH(AF2,$AH$1:$AH$13,0))"
"=SUMPRODUCT(($AI$2:$AI$13)*($AH$2:$AH$13=AF2))"
but I cant figure out the right one

[TMS]

Would think this:

Please Login or Register  to view this content.

[HansDouwe]

Please try in Totals!B2 and copy down:

Please Login or Register  to view this content.