INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Excel SUMIF and ISERROR

Excel SUMIF and ISERROR

(OP)
So I inherited a program that has the following formula:

=SUMIF('National Feeder'!$C$40:$C$45,markets!$E$73,'National Feeder'!$D$40:$D$45)

However I need to add ISERROR to this formula somehow, and when I try:

=SUM(IF(ISERROR('National Feeder'!$C$40:$C$45,markets!$E$73,'National Feeder'!$D$40:$D$45)

I receive this error: You've entered too many arguments for this function.

So I am not sure of the correct syntax to use to couple SUMIF and ISERROR without this error message coming up.

RE: Excel SUMIF and ISERROR

Hi,


=IFERROR(SUMIF('National Feeder'!$C$40:$C$45,markets!$E$73,'National Feeder'!$D$40:$D$45),”THIS IF ERROR”)


Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Excel SUMIF and ISERROR

(OP)
Appreciate it Skip, this worked like a charm

RE: Excel SUMIF and ISERROR

Igawa29,
Not that Skip is short of the little purple stars, but you should start using them as appreciation for help received. Click on Great Post! link to award a star to whoever helped you.

Have fun.

---- Andy

There is a great need for a sarcasm font.

RE: Excel SUMIF and ISERROR

(OP)
Thanks Andrzejek for the tip.

RE: Excel SUMIF and ISERROR

I’m gonna throw this in for no extra charge.

Since Excel 2007, I’ve been an avid user of Excel’s Structured Table features, of which there are many!

You can convert any proper table to a Structured Table via Insert > Tables > Table.

I have no idea what your table headings are, so I’m gonna make some up:
C40:C45 will be Region
D40:D45 will be Sales
markets E73 will be a range named SelectedRegion

So with the Structured Table named tRegionalSales in sheet National Feeder...

=IFERROR(SUMIF(tRegionalSales[Region],SelectedRegion,tRegionalSales[Sales]),””)


How’s that for a clearer and more understandable and maintainable expression?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close