Jeffrey Green
Well-known Member
- Joined
- Oct 24, 2007
- Messages
- 1,021
I do sumifs ALL the time. I used NAMED RANGES, all the time.
Today, when i enter
<tbody>
</tbody> and
<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.
Today, when i enter
=SUMIF(OnZats,"Y",DutyifPaid) |
<tbody>
</tbody>
=SUMIF(OnZats,"N",DutyifPaid) |
<tbody>
</tbody>
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.