Getting #N/A on a sumif formula!

[Jeffrey Green]

I do sumifs ALL the time. I used NAMED RANGES, all the time.

Today, when i enter [TABLE="width: 51"]
<tbody>[TR]
[TD="width: 51"]=SUMIF(OnZats,"Y",DutyifPaid)[/TD]
[/TR]
</tbody>[/TABLE]
and
[TABLE="width: 51"]
<tbody>[TR]
[TD="width: 51"]=SUMIF(OnZats,"N",DutyifPaid)[/TD]
[/TR]
</tbody>[/TABLE]
i get $0 for the first one and i get #N/A for the second!

I copied all the data to a new sheet and is still broke.
There are Y's and N's in ONZATS, and thousands of dollars on DutyIfPaid.

Help, I have been doing this SAME worksheet all week for different years.

 

[jtakw]

Hi,

Has there been a Change in the Size of the named ranges?
They need to be the same...just a thought.

 

[Jeffrey Green]

No, and i even deleted the named ranges, and recreated them with different names, same

 

[Jeffrey Green]

SOLVED . . i had one #N/A in my DUTYifPAID column
thanks

 

[jtakw]

Glad you got it fixed