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.

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.

Offset Function
 

Is:

=SUM((OFFSET(Data!$J$1,2,0,38,))/SUM(OFFSET(Data!$I$1,2,*38,))

what you are looking for?

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.

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?

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?