Averaging a range of numbers using the indirect function

[j_brubaker]

I currently have the equation: =average('Enter Data Here'!C3:C33) in the second sheet. How can I apply the "indirect" function to this equation in a format that will allow me to drag the equation down the page?

Thanks
-Josh

 

[JoeMo]

You can drag the formula you posted down. The next cell down would be:

=AVERAGE('Enter Data Here'!C4:C34)

If that's not what you want, can you explain and/or illustrate the result you want when the formula is copied down?

 

[j_brubaker]

I need the range to be dynamic by using the INDIRECT function. I have the equation:

=average(INDIRECT("'Enter Data Here'!c"&row('Enter Data Here'!c3)&":'Enter Data Here'!c"&row('Enter Data Here'!c33)))

which has to be close. It keeps popping up with an error though.

 

[j_brubaker]

I got this equation to work using the same sheet:

=average(INDIRECT("a"&row(B3)&":a"&row(B33)))

however, I need to pull the same references from 'Enter Data Here' sheet.

Any idea how to make that work with this equation??

 

[j_brubaker]

Just FYI, through trial and error, I got the equation:

=average(INDIRECT("'Enter Data Here'!c"&row(A3)&":c"&row(A32))

which accomplished what I was looking for!

 

[Aladin Akyurek]

Why not just the following?

=AVERAGE('Enter Data here'!C:C)

Also:

=AVERAGE(INDEX('Enter Data here'!C:C,ROW(A3)):INDEX('Enter Data here'!C:C,ROW(A32)))<strike></strike>