+ Reply to Thread
Results 1 to 4 of 4

add cells which contain blanks resulting from IF formulae

  1. #1
    Registered User
    Join Date
    03-30-2006
    Posts
    32

    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. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    Try

    =sum(C3,A3,I3)

  3. #3
    Valued Forum Contributor
    Join Date
    09-23-2005
    Location
    Bristol, UK
    MS-Off Ver
    2007
    Posts
    664
    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
    Last edited by SamuelT; 10-22-2007 at 10:52 AM.

  4. #4
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    Assuming A3:BA3 contains just numbers or text as described then SUM is still adequate

    =SUM(A3:BA3)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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