Countif or Vlookup or something else?

[nparsons75]

Hi, I have a table which contains data in Col A (Part Description). I have a cell which I need to look at Col A, if Col A = Desc1, look in Column N and count the non blanks.

Is there a function out there to do this?

Thank you.

 

[tyija1995]

Okay so that formula will be looking at $A$17:$A$5000 and saying "Is this cell equal to 'Desc1' " then if so the next part says "Is this cell in Column E not blank?" If it is not blank AND col A is "Desc1" then the unary operator returns a 1 to increment with SUMPRODUCT.
So in your range it must be the case that there are 2 instances of Desc1 in $A$17:$A$5000 where the corresponding E column is not blank.

I'm guessing where you have 6 non blank cells in column E, then 4 of those do not have "Desc1" in column A?

EDIT: It could also be the case that the cell looks blank but isn't, i.e. holds a space " " - tricky to see!