Hi Guys,
As the title says, I am having trouble with this. This is the formula I have so far:
=SUMPRODUCT(('SPC-103R.xlsm'!Table1[Alloy]=A3)*('SPC-103R.xlsm'!Table1[Mesh Type]=B3)*('SPC-103R.xlsm'!Table1[Flux Type]=C3)*('SPC-103R.xlsm'!Table1[METAL%]=E3)*('SPC-103R.xlsm'!Table1[IPN]))
Here's the table I reference.
A3 B3 C3 E3
Sn62 Type 3 NC-SMQ92H 90
[TABLE="width: 637"]
[tr][td]IPN
[/td][td]Low Malcom
[/td][td]High Malcom
[/td][td]Low Metal% Shipping
[/td][td]High Metal % Shipping
[/td][td]Alloy
[/td][td]Mesh Type
[/td][td]Flux Type
[/td][td]METAL%
[/td][/tr][tr][td]81484
[/td][td]1850
[/td][td]2450
[/td][td]90.25
[/td][td]90.75
[/td][td]Sn63
[/td][td]Type 3
[/td][td]RMA-SMQ51AC
[/td][td]90.5
[/td][/tr][tr][td]81501
[/td][td]1525
[/td][td]2025
[/td][td]89.75
[/td][td]90.25
[/td][td]Sn63
[/td][td]Type 3
[/td][td]RMA-SMQ51AC
[/td][td]90
[/td][/tr][tr][td]81506
[/td][td]1800
[/td][td]2400
[/td][td]90.25
[/td][td]90.75
[/td][td]Sn62
[/td][td]Type 3
[/td][td]RMA-SMQ51AC
[/td][td]90.5
[/td][/tr][tr][td]81609
[/td][td]1850
[/td][td]2450
[/td][td]90.25
[/td][td]90.75
[/td][td]Sn63
[/td][td]Type 3
[/td][td]RMA-SMQ51AC
[/td][td]90.5
[/td][/tr][tr][td]81648
[/td][td]1850
[/td][td]2450
[/td][td]90.25
[/td][td]90.75
[/td][td]Sn63
[/td][td]Type 3
[/td][td]NC-SMQ51SC
[/td][td]90.5
[/td][/tr][tr][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/TABLE]