Try this (normally entered):

=SUMPRODUCT(--(NOT(ISERROR(A1:A100))),A1:A100)

Hope this helps.

Pete

On Feb 26, 8:42*am, "Jan Kronsell"
wrote:
I have this formula

* * * =SUM(IF(ISERROR(A1:A100),0,A1:A100))

entered as an array formula, to sum a column even if some of the cells
contains error values.

Now I wonder if it could be done using SUMPRODUCT or any other functions, to
avoid the array formula?

Jan