I cannot get this formula to work correctly.
=SUMIFS('Material needed for open orders'!$J$3:$J$445,'Material needed for
open orders'!$A$3:$A$445,"<&'Raw Material Planning'!$B$2:$B$132",'Material
needed for open orders'!$C$3:$C$445,"<='Material needed for open
orders'!$N$1",'Material needed for open orders'!$I$3:$I$445,'Raw Material
Planning'!Y$2))

I am trying to sum the material requirements ('Material needed for open
orders'!$J$3:$J$445) where the finished part number does not match a
pre-determined list ('Material needed for open orders'!$A$3:$A$445,"<'Raw
Material Planning'!$B$2:$B$132"), is less than or equal a given date (
'Material needed for open orders'!$C$3:$C$445,"<='Material needed for open
orders'!$N$1") where the material required matches a specific material
('Material needed for open orders'!$I$3:$I$445,'Raw Material Planning'!Y$2).
I can make some of the pieces of the statement work correctly with the
exception of not matching the pre-determined list of finish part numbers.