That is great, thank you so much :D You're a genius, bravo bravo :D

Once again, I thank you!

"T. Valko" wrote:

Try this:

=--AND(COUNT(A1:B1)=2,A1=0,B11)

Copy down as needed.

--
Biff
Microsoft Excel MVP


"JS25" wrote in message
...
Certainly:

'A' 'B' Expect Result -
0 0 0
0 1 0
0 2 1
0 3 1
1 0 0
1 1 0
1 2 0
1 3 0
2 0 0
2 1 0
2 2 0
2 3 0

Basically, the two conditions are that 'A' must be 0, and 'B' must be more
than 1.


"Mike H" wrote:

Hi,

Perhaps we could see a small amount of test data and the result you
expect.

Mike

"JS25" wrote:

Hi all,

I'd really appreciate help with what is, I'm sure, a simple problem
that I'm
too stupid to solve!

The problem - Using COUNTIF (I think), the problem is that it requires
two
criteria/conditions to be met:

For the range to be counted (as 1, NOT 2), A1 must have a value of 0
AND B1
must be more than 1. ONLY if these conditions are meet should the range
be
counted as 1.

Eagerly awaiting for reply,
JS25