Interesting....Regarding:
=sumproduct(--($F$6:$F$3000=0),--($G$6:$G$30000))

That formula matches Col_F cells with zero in them (no surprise there), but
it also matches Col_G values containing only an apostrophe or text or TRUE or
FALSE.

***********
Regards,
Ron

XL2002, WinXP


"Jim Thomlinson" wrote:

Countif can only handle one criteria... You want to use sumproduct for that...

=sumproduct(--($F$6:$F$3000=0),--($G$6:$G$30000))

Check out this link for more info...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


"ronnomad" wrote:

I have two columns of numbers but some cells in both columns are blank. I
only want to count the blank cells in one column if the corresponding cell in
the second column has a number. I have written the formula:
=COUNTIF($F$6:$F$3000,AND($F$6:$F$3000=0,$G$6:$G$3 0000))
but get no answer. Help.