#value

M

monika

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
 
G

Guest

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


.
Click to expand...
 
N

Nigel

The issue is that the sum function is seeing the #VALUE and cannot complete.
Why is there a #VALUE in the rows AR10:AR298 ?

Cheers
Nigel
 
J

Jerry W. Lewis

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

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

Jerry
 
Top