Excel SUMIF and ISERROR 2

[Igawa29]

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.

 

[SkipVought]

Hi,

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

[/tt]


Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Igawa29]

Appreciate it Skip, this worked like a charm

 

[Andrzejek]

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

Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[Igawa29]

Thanks Andrzejek for the tip.

 

[SkipVought]

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
D4045 will be Sales
markets E73 will be a range named SelectedRegion

So with the Structured Table named tRegionalSales in sheet National Feeder...
[tt]
=IFERROR(SUMIF(tRegionalSales[Region],SelectedRegion,tRegionalSales[Sales]),””)
[/tt]

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

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]