how to insert text as cell location in formula

[squidy37]

Hello this is my first post! I hope to find some very much needed excel tips here.

Let's say I have in cell A1 a text value of 'B1:B100'

I would like to use this text as a cell reference by calling it in a formula. For example:

=average(B1:B100)

but instead of typing B1:B100, I want to use A1 somehow. What is the syntax I need to use? Help would be greatly appreciated!

[TMS]

Try

=AVERAGE(INDIRECT(A1))


Regards

[squidy37]

Yes this worked! Thank you so much

[TMS]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save