COUNTIFS Function using Named Ranges

[Gesyca_is_joy]

I am trying to create a COUNTIFS Function in Excel 2007.
Essentially what i have is a named range, for the example we will say i named it "NATO". the function I am trying to write is
a count is does not equal "NATO" and equals yes. Here is a copy of the live formula (referencing tables with values in it, but hopefully you get the idea.

=COUNTIFS(I_RMCM_OPEN[Sub Vendor],"<>"&SubNames,I_RMCM_OPEN[SLA],"Overdue")

when i try it in my live document i get no returns, no errors but no returns. I am wondering what i did wrong. is the formula not evaluating the 4 text stings in the named range individually?

In this example, the first four values are the values of the named range "NATO" therefore if i were fun this function i should get a count of 1 because "tango" is not one of the values in the named range and it also equals "yes"

alpha	yes
bravo	no
Charlie	yes
Delta	no
tango	yes

<TBODY>
</TBODY>

 

[Gesyca_is_joy]

no dice, I am getting an error. I also tried to extend my named range to include a blank cell but that didnt work either

 

[Marcelo Branco]

no dice, I am getting an error. I also tried to extend my named range to include a blank cell but that didnt work either

What error? It worked perfectly for me!

M.