I use the statement =IF(COUNTIF(Area1!$B$2:$B$7,A4)>=1,"",ROW()). How
is this statement if the condition not only applies for the area in
Area1, but also in Area2 to have the value ""?
So, it is like COUNTIF Area1 OR Area2 True, False

Bart

Hi
One way

=IF(COUNTIF(Area1!$B$2:$B$7,A4)+COUNTIF(Area2!$B$2:$B$7,A4)>=1,"",ROW())

--
Regards

Roger Govier


"AA Arens" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I use the statement =IF(COUNTIF(Area1!$B$2:$B$7,A4)>=1,"",ROW()). How
> is this statement if the condition not only applies for the area in
> Area1, but also in Area2 to have the value ""?
> So, it is like COUNTIF Area1 OR Area2 True, False
>
> Bart
>

=SUMPRODUCT(--(A1:A10=1)+(B1:B10="b"),F1:F10)

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"AA Arens" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I use the statement =IF(COUNTIF(Area1!$B$2:$B$7,A4)>=1,"",ROW()). How
> is this statement if the condition not only applies for the area in
> Area1, but also in Area2 to have the value ""?
> So, it is like COUNTIF Area1 OR Area2 True, False
>
> Bart
>

=IF(OR(COUNTIF(Area1!$B$2:$B$7,A4),COUNTIF(Area2!$B$2:$B$7,A4)),"",ROW())

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"AA Arens" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I use the statement =IF(COUNTIF(Area1!$B$2:$B$7,A4)>=1,"",ROW()). How
> is this statement if the condition not only applies for the area in
> Area1, but also in Area2 to have the value ""?
> So, it is like COUNTIF Area1 OR Area2 True, False
>
> Bart
>