How do I Excel countif column a =? and column b = null ?
 

I am trying to count all the "Nissans" in column a where in the same row in
column b is blank without having to create additional columns, I am sure that
there should be a way of creating a countif and statement but do not seem to
be able to make it work.

How do I Excel countif column a =? and column b = null ?
 

=SUMPRODUCT((A1:A100="Nissan")*(B1:B100=""))

Jerry

tiff wrote:

I am trying to count all the "Nissans" in column a where in the same row in
column b is blank without having to create additional columns, I am sure that
there should be a way of creating a countif and statement but do not seem to
be able to make it work.