Thread: Countif...and
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
heater heater is offline
external usenet poster
 
Posts: 17
Default Countif...and

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.