Adding to Sumproduct

[trone77]

=IF(SUMPRODUCT(--([2021.xlsb]MASTER!$H$5:$H$49=$C5),--([2021.xlsb]MASTER!$I$5:$I$49=$D5)*([2021.xlsb]MASTER!$AB$5:$AB$49=[2021.xlsb]MASTER!$B$5)),"x","")

Thee above formula works, however I would like to add the following to it.


([2021.xlsb]MASTER!$J$5:$J$49=$C5),--([2021.xlsb]MASTER!$K$5:$K$49=$D5)

([2021.xlsb]MASTER!$L$5:$L$49=$D5),--([2021.xlsb]MASTER!$M$5:$M$49=$E5)

 

[jorismoerings]

Hi,

You came up with a very specified question however we can't help without proper and sufficient information. We're not mind-readers so without the information on what you're trying to achieve with the addition, some sample data to check if we got it right, this will probably stay un-answered.
Could you provide with some sample data and explain in more detail what you're trying to achieve with adding the data range to the SUMPRODUCT function.