Offset Function

[SMH]

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.

 

[PCLIVE]

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

 

[Jarek Kujawa]

Is:

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

what you are looking for?

 

[SMH]

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?

 

[SMH]

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?

 

[David Biddulph]

You posted virtually the same question in another group, so let's not split
the thread.