Array Formula

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Calculate average in intervals 1
INDEX return multiple columns 1
Calculate end date and time 1
Mapping integers to strings 6
Changing function name in formula 17
Cannot access to Office Insider 0
Counting each time text appears in range??? 1

Top