Coppy formula using OFFSET


E

Eric_G

I am attempting to create a worksheet formula as follows:

Cell A3 is to reflect the PRODUCT of Cells A1:A3 on Worksheet2.
Cell A4 is to reflect the PRODUCT of Cells A4:A6 on Worksheet2.
Cell A5 is to reflect the PRODUCT of Cells A7:A9 on Worksheet2, and so on.

Unfortunately, when I copy the formula from Cell A3 to A4, I'm not using the
OFFSET function properly. Any suggestions?
 
Ad

Advertisements

M

Mike H

that'll teach me to test before i post!! Try this instead

=SUM(OFFSET(Sheet2!$A$1,(ROW(1:1)-1)*3,,3))

Mike
 
E

Eric_G

Hi Mike,
Thanks for your assistance. By changing "SUM" to "PRODUCT", the formula is
doing exactly as requested.

Thanks.

a) I am looking to
 
Ad

Advertisements


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

Top