Hi,

The formula for your third column would be

=--AND(A1=0,B11)

for an overall count:

=SUMPRODUCT(--(A1:A12=0),--(B1:B121))

or if you are using 2007:

=COUNTIFS(A1:A12,0,B1:B12,"1")

--

If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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