# add cells which contain blanks resulting from IF formulae

1. ## add cells which contain blanks resulting from IF formulae

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).

2. Try

=sum(C3,A3,I3)

3. 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

4. Assuming A3:BA3 contains just numbers or text as described then SUM is still adequate

=SUM(A3:BA3)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1