Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy question? Page numbers | Excel Discussion (Misc queries) | |||
Easy VB code question | Excel Discussion (Misc queries) | |||
OsCommerce - Easy Populate Script - CSV/TXT Conversion Problem. | Excel Discussion (Misc queries) | |||
new user with easy question? not easy for me | New Users to Excel | |||
is there an easy way to move parts of cells around | Excel Discussion (Misc queries) |