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?
|
Similar Threads
