Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf multiple conditions
Hi all,
I have what seems to be a simple problem, but for some reason I cannot get this formulae to work.... =IF(AND(COUNTIF(Week1!$G$2:G11,Week2!G2)=0,(Week1! $B$2:B11,Week2!B2)=0,"No","Yes")) I know I am doing something wrong but not sure what?! Probably me being stupid and missing something simple here. Thanks in advance! Ash. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf multiple conditions
=IF(AND(COUNTIF(Week1!$G$2:G11,Week2!G2)=0,COUNTIF (Week1!$B$2:B11,Week2!B2)=0),"No","Yes")
Bob Umlas Excel MVP "ashg657" wrote: Hi all, I have what seems to be a simple problem, but for some reason I cannot get this formulae to work.... =IF(AND(COUNTIF(Week1!$G$2:G11,Week2!G2)=0,(Week1! $B$2:B11,Week2!B2)=0,"No","Yes")) I know I am doing something wrong but not sure what?! Probably me being stupid and missing something simple here. Thanks in advance! Ash. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf multiple conditions
Great stuff, thanks Bob!
What I am trying to achieve is having 2 worksheets, one for Week1 and one for Week2, In week 2 I have a list of amounts which i want to lookup on Week1 to see whether or not they existed in Week1, if they do then return "Yes" else return a "No", Question is - this formulae will do the job yes? If not could you point me in the right direction? Many thanks. "Bob Umlas, Excel MVP" wrote: =IF(AND(COUNTIF(Week1!$G$2:G11,Week2!G2)=0,COUNTIF (Week1!$B$2:B11,Week2!B2)=0),"No","Yes") Bob Umlas Excel MVP "ashg657" wrote: Hi all, I have what seems to be a simple problem, but for some reason I cannot get this formulae to work.... =IF(AND(COUNTIF(Week1!$G$2:G11,Week2!G2)=0,(Week1! $B$2:B11,Week2!B2)=0,"No","Yes")) I know I am doing something wrong but not sure what?! Probably me being stupid and missing something simple here. Thanks in advance! Ash. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF with multiple conditions | Excel Discussion (Misc queries) | |||
CountIf with multiple conditions | Excel Worksheet Functions | |||
Multiple conditions on a countif | Excel Worksheet Functions | |||
COUNTIF and multiple conditions | Excel Worksheet Functions | |||
COUNTIF - multiple conditions | Excel Worksheet Functions |