#value

[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

 

[Frank Kabel]

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

 

[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


.

 

[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

 

[Jerry W. Lewis]

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

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

Jerry