Getting #N/A on a sumif formula!

Jeffrey Green

Well-known Member
I do sumifs ALL the time. I used NAMED RANGES, all the time.

Today, when i enter


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.


Well-known Member

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

Some videos you may like

This Week's Hot Topics