Is it Possible to Combine these 3 Formulas??

[thewiseguy]

I am trying to populate quantities of various products that sit in various places within another worksheet. Insteas of having 3 columns showing totals for each different product type, I was hoping to have one column equal to QUANTITY. Is it possible to combine these 3 formulas? Any help is greatly appreciated!


=(IF(SUMPRODUCT(--('Line Item (input)'!$W$3:$W$2002=A8),'Line Item (input)'!$Y$3:$Y$2002)=0,"",SUMPRODUCT(--('Line Item (input)'!$W$3:$W$2002=A8),'Line Item (input)'!$Y$3:$Y$2002)))*(XLOOKUP(A8,Table_Rental[MaskedPartNumber],Table_Rental[Lamps Per Fixture],XLOOKUP(A8,Table_Lamp[MaskedPartNumber],Table_Lamp[Lamps Per Fixture],XLOOKUP(A8,Table_Materials[MaskedPartNumber],Table_Materials[Lamps Per Fixture],XLOOKUP(A8,Table_Accessory[MaskedPartNumber],Table_Accessory[Lamps Per Fixture],XLOOKUP(A8,Table_Control[MaskedPartNumber],Table_Control[Lamps Per Fixture],XLOOKUP(A8,Table_Fixture[MaskedPartNumber],Table_Fixture[Lamps Per Fixture],"",0)))))))

=IF(SUMPRODUCT(--('Line Item (input)'!$AB$3:$AB$2002=A8),'Line Item (input)'!$AC$3:$AC$2002)=0,"",SUMPRODUCT(--('Line Item (input)'!$AB$3:$AB$2002=A8),'Line Item (input)'!$AC$3:$AC$2002))

=(IF(SUMPRODUCT(--('Line Item (input)'!$AD$3:$AD$2002=A8),'Line Item (input)'!$AE$3:$AE$2002)=0,"",SUMPRODUCT(--('Line Item (input)'!$AD$3:$AD$2002=A8),'Line Item (input)'!$AE$3:$AE$2002))

 

[thewiseguy]

i just combined the 3 formulas using &""& and hid the 3 columns