How to count the number of products between two same length ranges is 0 in Excel-CodePudding

I have two ranges of columns that I would like to count the number of times the product between two cells at corresponding indexes is 0. Right now I am currently counting via brute force via the below example.

=IF(OR(A3=0,F3=0),1,0) IF(OR(B3=0,G3=0),1,0) IF(OR(C3=0,H3=0),1,0) IF(OR(D3=0,I3=0),1,0) IF(OR(E3=0,J3=0),1,0)

Is there a way to accomplish the same but without having to write out all of the IF statements and simply pass the arrays?

Below is an example where columns with same name will be multiplied and in the final "Outcome" column i want to get the count where that product is 0.

CodePudding user response：

If I understand your logic, I think this will do it:

=SUM(N(((A2:E2=0) (F2:J2=0))>0))