View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default


"Roger Govier" wrote in message
...
Try
=SUMPRODUCT(--(A1:A10="A"),--(B1:B10="YES"))


:-)