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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset Function
Are you trying to get the sum of two different cells (J3 and J39) divided by
the sum of two other cells (I3 and I39)? =(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)) )) HTH, Paul -- "SMH" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset Function
Is:
=SUM((OFFSET(Data!$J$1,2,0,38,))/SUM(OFFSET(Data!$I$1,2,*38,)) what you are looking for? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset Function
Yes, I'm trying to sum and then divide. I.E. (J3:J39)/(I3:I39)
The result is still not giving me what I get without using the offset function. Any ideas why? "PCLIVE" wrote: Are you trying to get the sum of two different cells (J3 and J39) divided by the sum of two other cells (I3 and I39)? =(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)) )) HTH, Paul -- "SMH" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset Function
Your formula won't work because I'm trying to take the sum of multiple rows
divided by the sum of another set of rows! I.E. (J3:J39)/(I3:I39). The problem I was having is that when I "refresh" my data, the formula changes! So someone recommended using the $, but that didn't work either, which is why I'm trying to use the offset function. It seems to be keeping the formula in place when "refreshing" but I can't seem to get the formula to be pulling the proper results, which is why I was thinking I had a parenthese error. Any other suggestions? "Jarek Kujawa" wrote: Is: =SUM((OFFSET(Data!$J$1,2,0,38,))/SUM(OFFSET(Data!$I$1,2,Â*38,)) what you are looking for? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Offset Function
You posted virtually the same question in another group, so let's not split
the thread. -- David Biddulph "SMH" wrote in message ... Your formula won't work because I'm trying to take the sum of multiple rows divided by the sum of another set of rows! I.E. (J3:J39)/(I3:I39). The problem I was having is that when I "refresh" my data, the formula changes! So someone recommended using the $, but that didn't work either, which is why I'm trying to use the offset function. It seems to be keeping the formula in place when "refreshing" but I can't seem to get the formula to be pulling the proper results, which is why I was thinking I had a parenthese error. Any other suggestions? "Jarek Kujawa" wrote: Is: =SUM((OFFSET(Data!$J$1,2,0,38,))/SUM(OFFSET(Data!$I$1,2,*38,)) what you are looking for? |
Reply |
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 |