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. |
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. |
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. |
All times are GMT +1. The time now is 08:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com