Easy one for CountIF
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 |
Easy one for CountIF
=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 |
All times are GMT +1. The time now is 11:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com