| 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? |
| 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) | |||
Threaded Mode
