Formula ends with #NUM! but need to equal zero if nothing returns

**mort.marshall.20** · 11-13-2013, 04:36 PM

Hello,

I have this formula that i need to return zero if there is no value to return. This is for a summary page on a workbook with 30 sheets. The formula is as follows:

=INDEX('Corp Nov - 13'!$A$1:$I$1000,SMALL(IF('Corp Nov - 13'!$A$1:$A$1000='Daily Summary'!$I$1,ROW('Corp Nov - 13'!$A$1:$A$1000)),ROW(1:1)),1)

Thanks in advance for any help. I am new to this so if there is additioall information just let me know.

**Sam Capricci** · 11-13-2013, 04:38 PM

did you try adding iferror( to the front and "0") at the end?

**mort.marshall.20** · 11-13-2013, 04:54 PM

I sure didn't, That worked like a charm. I figued it would be somthing simple like that. Thank you very much!

**Sam Capricci** · 11-13-2013, 05:25 PM

Sure, and don't forget to mark your post as solved under the thread tools at the top. And (shamelessly) I'm not averse to getting a bump for reputation points.