Help with Product Formula "or"

[Slongy]

Hi

I am using a Sum product formula that checks two cells for validation:

=SUMPRODUCT(--('Complete Pipe'!$N$9:$N$3250=E178),--('Complete Pipe'!$Y$9:$Y$3250=$F$161),'Complete Pipe'!$BH$9:$BH$3250)

I need it to check a 3rd point as well. So I need it to validate that E178 matches, then check whether F161 OR J161 match, then return the results from BH

Can someone help me get the formula right?

I also need to do a 3 point check, where there isn't an "or", so it checks 3 pieces of information and returns the result if all 3 match at the same time

Thanks in advance as always