I am trying to use this formula =AVERAGE('Control Group 1'!I5:I315) it gives me this error #DIV/0
M mikeeee Oct 18, 2004 #1 I am trying to use this formula =AVERAGE('Control Group 1'!I5:I315) it gives me this error #DIV/0
J Jonathan G. Oct 18, 2004 #2 Somewhere in the range from I5 to I315 there are probably blank cells. Check that first... JRG
