| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Offset formula | Excel Worksheet Functions | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| 1 OFFSET FORMULA, I'M NOT SURE WHAT DOES IT MEAN!!!!!! | Excel Discussion (Misc queries) | |||
| Offset formula | Excel Worksheet Functions | |||
| Macro to coppy cells to certain rows depending on value in cell | Excel Discussion (Misc queries) | |||
Linear Mode
