Looks like you need 2 different formula's:

=SUMPRODUCT(--(I2:AV2="Sht In Form"),--(I3:AV3="YES"))
=SUMPRODUCT(--(I2:AV2="Sheet Present"),--(I3:AV3="YES"))

--
Regards,
Dave


"Barb Reinhardt" wrote:

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!