Your options a

1. Fix the errors.
2. Change the formula so that errors and blanks return zero.
3. Create a new range which doesn't include the errors/blanks.

Before you do anything, you need to determine what the proper cash flows are.
Remember that IRR requires a cash flow for each period, even if it's zero. I
suspect that #2 is your best bet, but only your data know for sure.

--
Regards,
Fred


"hall12" wrote in message
...
How do I obtain an IRR that reads a range of data, i.e. cash outflow and
inflows, but ignores error values and blank cells?