Results 1 to 5 of 5

How to make excel ignore errors when summing up cells

Threaded View

  1. #1
    Registered User
    Join Date
    02-12-2009
    Location
    oslo, Norway
    MS-Off Ver
    Excel 2010
    Posts
    45

    How to make excel ignore errors when summing up cells

    Hello,

    How can I make excel sum up a colum, and ignore cells shown as #I/T?
    This error sign might not be the same in the english version of excel.

    If I try to sum up cells with the error value, the feedback will also be #I/T.

    I have uploaded a screenshot to illustrate the problem for You

    (The reason for the faulty cells is that the date does not contain any values)

    thanx! =)

    Faulty formula is now; =(SUM(B307:B316))
    Attached Images Attached Images
    Last edited by abrunstad; 06-02-2009 at 05:31 PM.

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