I am looking to add the contents of a column. Some of the values contain
#N/A. The info was put into a data filter. Column A is the Name, Column B is
the Year, and Column C is the Value.

If I sort the data filed to only display 2007, I would like the total for
this.

Is there a way to add the all of the values in the column together, but
ingnore the #N/A?

example of entire sheet:

Object 1 2007 2
Object 2 2008 #N/A
Object 3 2007 #N/A
Object 4 2006 1

Total 3

Example of desired:

Object 1 2007 2
Object 3 2007 #N/A

Total 2

=SUM(IF(ISNUMBER(C2:C200),C2:C200,0)*(B2:B200=2007))

Entered with Ctrl+Shift+enter rather than just enter since this is an array
formula.

--
Regards,
Tom Ogilvy




"BZeyger" wrote:

> I am looking to add the contents of a column. Some of the values contain
> #N/A. The info was put into a data filter. Column A is the Name, Column B is
> the Year, and Column C is the Value.
>
> If I sort the data filed to only display 2007, I would like the total for
> this.
>
> Is there a way to add the all of the values in the column together, but
> ingnore the #N/A?
>
> example of entire sheet:
>
> Object 1 2007 2
> Object 2 2008 #N/A
> Object 3 2007 #N/A
> Object 4 2006 1
>
> Total 3
>
> Example of desired:
>
> Object 1 2007 2
> Object 3 2007 #N/A
>
> Total 2
>