Offset Function

  • Thread starter Thread starter SMH
  • Start date Start date
S

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.
 
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
 
Is:

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

what you are looking for?
 
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?
 
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?
 
You posted virtually the same question in another group, so let's not split
the thread.
 
Back
Top