How to make excel ignore errors when summing up cells

**abrunstad** · 06-02-2009, 10:09 AM

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

**JONvdHeyden** · 06-02-2009, 10:18 AM

It is generally better to handle the errors where they occur so that you don't have the errors in the range. Although you can use the following:

=IF(ISNUMBER(B307:B316),B307:B316))

And commit this with CONTROL+SHIFT+ENTER because it is an array formula.

**JBeaucaire** · 06-02-2009, 10:27 AM

Wouldn't this non-array option work:

=SUMIF(B307: B316,"<>#I/T")

**abrunstad** · 06-02-2009, 10:33 AM

Thanks guys!

Both solutions worked perfectly!

However, I choose tho take the problem where it first occured.

(if error turn blank).

Thanks Again! =)

**JBeaucaire** · 06-02-2009, 11:29 AM

Smart...always best to solve it that way.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the "scales" icon in our posts to leave Feedback, it is appreciated)