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