Countif...and

[heater]

I need a formula to count the No's in column S only if column J is Yes: IF
J29:J80 is "Yes" and S29:S80 is "No" then count, If J29:J80 is "No" and
S29:S80 is "No" DO NOT count the No in column S.

 

[M Kan]

=sumproduct(--(J29:J80="yes"),--(S29:S80="no"))