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

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

HTH

"rivers" wrote:

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: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