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?