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

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

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
.

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


wrote in message
...
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
.

=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

.