Excel - Adding and Subtracting issue

August 2016


I have a row of 4 cells each containing an "if formula" to get information from another worksheet. An example of the formula in these cells is: =IF('2009'!E2>0,'2009'!E2,""). My problem is trying to find the total of these cells. I'm adding 3 and subtracting 1.

The formula I'm using is:

The formula works great if all 4 cells have a value in it; however, if one is blank, #VALUE! shows in the cell. Is it possible to do what I'm trying to?

Thanks for any help.


Try this it works on excel 2007 but it should work on lower excels.


Thanks to Helper for this tip on the forum.

See also :

This document entitled « Excel - Adding and Subtracting issue » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.