Easy one for CountIF

[Guest]

Hi peeps require help but cant get my head around it.
i require a count if formula to count the amount of times a team number
reaccures but then i want it to then count the amount of times the column
next to the team name says "yes" if there is no yes then i dont want it to
count. heres what i have so far but it keeps returning "0"

=COUNTIF(Summary!L:L,(Summary!L:L="Yes"*AND Summary!D=C2))

Column L being Yes No values and D being "Team 101" and higher
and C2 being the team inwhich i want it to find in column D hope theres
enough info

thanks before hand

 

[Guest]

=Sumproduct(--(Summary!L1:L200="Yes"),--(Summary!D1200=C2))

Note SUMPRODUCT must be a range and cannot be a colummn i.e D is invalid

HTH