Thread: How do I Excel countif column a =? and column b = null ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jerry W. Lewis
 
Posts: n/a
Default 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.

Reply With QuoteReply With Quote