this thread confuse a novice....someone has to check the real applicable
formula....when G:G contains a negative number...both formula confuse each
other...

"Ron Coderre" wrote:

Try this:

This will count true blanks with corresponding numbers
=SUMPRODUCT(ISBLANK(F6:F3000)*ISNUMBER(G6:G3000))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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.