Help Modifying a Formula - eliminate #DIV/0! result

[easybpw]

Hello! Thanks in advance for all the help. This board has been great over the years. I have this formula, =SUM($B$23:$B$31)-SUM($A$19:$B$19)/COUNTBLANK($B$23:$B$31), and it works like I intended except for one small issue. If there are no blank cells when the countblank function starts the result is #DIV/0!. How can I eliminate the #DIV/0! result? I would prefer the answer to the formula to be a -0- in the cell but will accept an empty cell as well.

Thanks again!

Bill

 

[AhoyNC]

If you are using Excel 2007 or later you can use the IFERROR function.

=IFERROR(SUM($B$23:$B$31)-SUM($A$19:$B$19)/COUNTBLANK($B$23:$B$31),0)

If you are using Excel 2003 look at the ISERROR function.