SUMMPRODUCT inconsitencies

[DataFanatic]

I have used SUMPRODUCT in the following way:
=SUMPRODUCT((CNUM=A6)*(LTD <=$F$1)) where CNUM is a named range of customer numbers and LTD is a named range of numeric values.
$F$1 currently has the value of 10. I have created a new sheet with updated data and #N/A is being returned as opposed to a count of the LTD data.
The first part of the formula is working in that =SUMPRODUCT((CNUM=A6)* 1) returns a count of the customer numbers from the data list.
I have broken apart each part of the formula to identify differences from the sheet that works, to no avail.
Does anyone have any thoughts as to what direction I should go from here?

Thanks in advance.

 

[GlennUK]

What are the definitions of the names CNUM and LTD?

Does LTD have any entries of #N/A ?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[bluedragon2]

Are the ranges the same size?

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[DataFanatic]

As always you guys are superior. Glenn, your question tied right in with Blues query of the range size. There was one additional cell in the CNUM range from the LTD range. That change fixed it.

Thanks again for your knowledge and willingness to help us mortals.