O.K. then:

Say we want to sum E1 thru E20 and remove ALL errors:

=SUM(IF(ISNUMBER(E1:E20),E1:E20,""))

This is an array formula that must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key.
--
Gary''s Student - gsnu200822


"Biff" wrote:

I'm not sure I understand and maybe I didn't use the correct words. I have
column I need to summarize using the sum function, but it has cells with
formulas that have derived the #DIV/0! error message. Is there a way that I
can still sum the column because write now I am getting the same #DIV/0! in
my results for the sum function.

"Gary''s Student" wrote:

1. Insert a column
2. Select a cell in the new column
3. enter:
=0/0
--
Gary''s Student - gsnu200822


"Biff" wrote:

Is there a way that I can add a column that includes #DIV/0!

Biff