If iserror sum - how??????

Greetings! I have a rather unique IF ISERROR formula that I need to create, but I can't quite seem to get it to work. I'm essentially wanting to do an IF ISERROR function on a SUM formula, but the SUM formula is not the straighforward type. It is:

Please Login or Register  to view this content.

It is a SUM function to calculate a Percent % Change, but I need to wrap it in an IF ISERROR function so that I don't get the #DIV/0 whenever there aren't numbers to calculate.

I think Excel 2007 has IFERROR which is better for what you want.

Formula:

Please Login or Register  to view this content.

You can replace "" with whatever you want to be returned if it would have been an error.

According to your profile, you have Excel 2007. Excel 2007 has the IFERROR function.

Try this:

=IFERROR((SUM(O7:O84)-SUM(M7:M84))/SUM(M7:M84),"")

This will change any error to a blank cell.

I was definitely over-complicating it. Thank you both!!

Glad we could help. Thanks for the rep!