COUNTIFS with a "" Referenced Cell

[kparadise]

Hello,

I am working on a COUNTIFS statement and have 2 of my 3 criteria down.

=COUNTIFS($B$16:$B$179,"<>*L2*",J$16:J$179,">0", M$16:M$179,"<>"&"")

This last range of data is where I cannot figure out how to use the formula. Range M16:M179 is a column I created by using an INDEX/MATCH. The INDEX/MATCH formula which I have used to generate column M is: =IFERROR(INDEX('Sheet1'!$BJ$3:$BJ$167, MATCH($B110, 'Sheet1'!$BI$3:$BI$167, 0)), ""). So I think my COUNTIFS formula is still picking up all the blank rows in column M.

=COUNTIFS($B$16:$B$179,"<>*L2*" = 4 ,J$16:J$179,">0" = 5 , M$16:M$179,"<>"&"" = 7 ) The answer I am getting is 9; but I want to get 2. I need my formula to remove (or not count) the blanks in column M.

 

[Jonmo1]

What type of value is your formula in M returning (when it's NOT "") ?
Text or Number? Or could be either ?

If it's TEXT use "?*" as the criteria
If it's number, use ">=0"

 

[kparadise]

Boom!