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