Reassign Range in Average Function

[Kzinoue]

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:UseFELayout/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0pt 5.4pt 0pt 5.4pt; mso-para-margin:0pt; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--> Hi, I’m not sure if this is right place to ask this question, but I’m pretty desperate now, so here I am.

I need help on how to re-assign the range for Averaging values without changing what is written in Average function. I’m thinking to do something like this:

= Average(RangeStart: RangeFinish)

and I want to set: RangeStart = A250, RangeFinish = B1050

Something like this, and assigned values to the RangeStart and RangeFinish are valuables based on some other calculations for given conditions.

Any suggestion? Am I even clear with my own question?
Thanks,

 

[Scott Huish]

You haven't said what your other formulas return, is it just the row number for each part?

 

[T. Valko]

Hi, I’m not sure if this is right place to ask this question, but I’m pretty desperate now, so here I am.

I need help on how to re-assign the range for Averaging values without changing what is written in Average function. I’m thinking to do something like this:

= Average(RangeStart: RangeFinish)

and I want to set: RangeStart = A250, RangeFinish = B1050

Something like this, and assigned values to the RangeStart and RangeFinish are valuables based on some other calculations for given conditions.

Any suggestion? Am I even clear with my own question?
Thanks,

Try something like this...

Use cells to hold the calculations for the range boundary variables.

D1 = 250
E1 = 1050

Then:

=AVERAGE(INDEX(A:A,D1):INDEX(B:B,E1))

 

[Kzinoue]

Worked! Thank you very much, guys!

 

[T. Valko]

You're welcome. Thanks for the feedback!