I think you want

=SUM(IF(NOT(ISERROR(A1:A100)),A1:A100)

which is an error, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"HeatherC" wrote in message
...
How do I sum a range of cells that include a #N/A error. I want the #N/A
cells to register as 0. Currently the total returned is also #N/A.
Thanks