Count or Sumproduct If Meeting In-Cell Specific

[jalifid11]

I have a list

David July 11 Yes
Tony July 16 Yes-Issue
Bobby July 13 No
David July 11 Yes-Issue


What I am trying to do is count David, on July 11, with the "Yes", even the "Yes-Issue"...

I know I can do it by =Countif(c1:C4="Yes*") and that will count the Yes's even if it has "Yes-Issue" in the cell...

But I am trying to do it based on multiple Criteria (ie, David, on July 11, Yes)..

I've tried =Sumproduct(--(A1:A4="David),--(B1:B4="July 11"),--(C1:C4="Yes*")
but the sumproduct isn't look for anything that says "Yes".. it's looking for Yes*.. If I take off the (*) then it only finds 1 Yes...


HELP !!!!

 

[Marcelo Branco]

Maybe this

=SUMPRODUCT(--(A1:A4="David"),--(B1:B4="July 11"),--ISNUMBER(SEARCH("Yes",C1:C4)))

HTH

M.