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
=SUMIF(OnZats,"Y",DutyifPaid)

<tbody>
</tbody>
and
=SUMIF(OnZats,"N",DutyifPaid)

<tbody>
</tbody>
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

Well-known Member
Hi,

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

Top