In the example It gave you three?

another method would be
=countif(A1:A100,"2")-sumproduct(--(A1:A100="2"),--(B1:B100<""))

" wrote:

Thank you, the
=sumproduct(--(A1:A100="2"),--(B1:B100<""))

worked!

Next question though.......what if I want to do the same sort of
thing, except this time I only want to include where column B -is-
blank?
I tried substituting and equal sign instead of <, but it just picks
up every row....
thx again!