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