Coppy formula using OFFSET
 

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?

Coppy formula using OFFSET
 

Try this

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

Mike

"Eric_G" wrote:

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?

Coppy formula using OFFSET
 

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

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

Mike

"Mike H" wrote:

Try this

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

Mike

"Eric_G" wrote:

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?

Copy formula using OFFSET
 

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

Thanks.

a) I am looking to

"Mike H" wrote:

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

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

Mike

"Mike H" wrote:

Try this

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

Mike

"Eric_G" wrote:

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?

Copy formula using OFFSET
 

Hi,

Here is another variation

=PRODUCT(OFFSET(A$1,ROW(A1)*3-3,,3))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Eric_G" wrote:

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

Thanks.

a) I am looking to

"Mike H" wrote:

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

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

Mike

"Mike H" wrote:

Try this

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

Mike

"Eric_G" wrote:

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?