| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset Function
I need assistance trying to use the Offset funtion with a formula I had
already created. Current formula: =IFERROR(SUM(Data!J3:J39)/SUM(Data!I3:I39), ) Trying to use Offset: =SUM((OFFSET(Data!$J$1,2,0):OFFSET(Data!$J$1,38,0) )/SUM(OFFSET(Data!$I$1,2,0):OFFSET(Data!$I$1,38,0))) What am I missing?? It isn't working properly! Any assistance is appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL2002 - OFFSET function and LARGE function | Excel Worksheet Functions | |||
| Help with OffSet Function! | Excel Worksheet Functions | |||
| Offset Function | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Using the Offset Function | Excel Worksheet Functions | |||
Threaded Mode
