Alternative to Bob's function:

=sum(if(isnumber(C3:C31),C3:C31))

Still array entered.

It doesn't use =iserror(), but I think it's easier to understand <bg.

wrote:

I'm trying to add up a column of numbers and some of the cells have
#N/A or #DIV/0! which causes my summation to come up as an error as
well.

I'd like to keep my #N/A's in the cells and use the ISERROR function
and thought it should be embedded into an IF statement. Can any help
me do this?

Thanks

Mike

--

Dave Peterson