Easier way to reference other cells for the end and start points for average formulas?

Hello,
Is there an easier way for me to do the following:
=AVERAGE(F4:F24)
But the start and end point values change depending on the worksheet.

So I end up having seperate reference cells for the start and end point values, 4 and 24 in this case.

My formula ends up looking like this, but it seems way too complicated:
=AVERAGE(INDIRECT(ADDRESS(INDIRECT(ADDRESS(1,1)),6)):INDIRECT(ADDRESS(INDIRECT(ADDRESS(2,1)),6)))
A1=4
A2=24

I have row / column functions set up also so I can add rows and columns as necessary, just curious if there's a different or better method of doing this.

If it is going to be column F where the data is located, then you can do this:

=AVERAGE(INDIRECT("F"&A1&":F"&A2))

If you put the column letter in A3, then you could have this:

=AVERAGE(INDIRECT(A3&A1&":"&A3&A2))

Hope this helps.

Pete

Thanks this helped a lot.

Glad to help.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete