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?