Yet another one:

=SUMIF(A1:A7,"<1E100")

--
Biff
Microsoft Excel MVP


"Ivan" wrote in message
...
Hello

In a column A1:A100 I have formulas, where the results are numeric number
or an error of type #REF!. I would like to have a sum of all cells, where
there not an error in them and I would like to have this sum in one cell
(with only one formula - somehow SUMIF ?)?

Example for cells A1:A7:
--------------------
A B
1 3
2 4
3 1
4 #REF!
5 2
6 #REF!
7 5
--------------------

Sum = 3 + 4 +1 +2 + 5 = 15

Any idea?


Ivan