Thread: #value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default #value

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

.