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.