Array Formula

[Geoffrey Zhu]

Hi Everyone,

I recently find the array formula very powerful, but I
just encountered a problem.

I want to get the product of (1+2*A1)/A2/3,
(1+2*A2)/A3/3, ..., (1+2*A999)/A1000/3. I use the
following formula:

{=SUM((1+2*A1:A999)/A2:A1000/3)} but get an error.

Does anyone know how to use an array formula to solve
this?

Thanks,
Geoffrey

 

[Tom Ogilvy]

Worked fine for me. Do you have zeros or blanks in your data?

 

[Domenic]

See if this will work for you...

=SUM(IF(A2:A1000<>0,(1+2*A1:A999)/A2:A1000/3))

....entered using CONTROL+SHIFT+ENTER.

Hope this helps!

 

[josef.angel]

Hi Geoffrey
are you missing a bracket.
after division the sign?

{=SUM((1+2*A1:A999)/(A2:A1000/3)}
angel.