=SUM(IF(ISNUMBER(AR10:AR298),A10:AR298))

will ignore errors. Must be array entered (Ctrl-Shift-Enter)

Jerry

wrote:

i am simply using :
=sum(ar10:ar298)

thanks



-----Original Message-----
Hi
what is the formula that produces this #VALUE error?

--
Regards
Frank Kabel
Frankfurt, Germany


monika wrote:

hi

i am takign a sum of rows from 10 to 298. inbetween the
row their is one cells which has #value. because of

which

the sum also gives as #value. How can i rectify that.

thanks in advance

.