Complicated SUMPRODUCT
I need a formula to do the following:
If I2:AV2 = "Sht In Form" and I3:AV3 = "YES"
If I2:AV2 = "Sheet Present" and I3:AV3 = "YES"
What I really need is to count when the first set intersects the second set
and I'm not sure how to write that equation.
Thanks!
|