add cells which contain blanks resulting from IF formulae

**raydaw** · 10-22-2007, 10:22 AM

HELP - I have several cells I want to sum but am getting the #VALUE error. This is because some of the cells contain an IF formulae to avoid getting the #ERROR value when dividing by 0.

I have tried just using simple =C3+A3+I3 or =sum(C3+A3+I3).

**daddylonglegs** · 10-22-2007, 10:28 AM

Try

=sum(C3,A3,I3)

**SamuelT** · 10-22-2007, 10:48 AM

Hi,

Alternatively, if you've got a large range (let's say A3:BA3) you can do the below formula. It'll mean that even if there are error messages in your cells, Excel will only Sum the numbers. This is an array formula, so you need to press CTRL+SHIFT+ENTER to get it working. You'll get curly brackets around it to show it's an array:

=SUM(IF(ISNUMBER(A3:BA3),A3:BA3))

HTH,

SamuelT