Indirect

[sfitzpat11]

Hello,
I am trying to use the "indirect" function so when I insert a row, the formula does not change (rows stay the same). Having trouble using the indirection function the following formula. Any help would be appreciated.
"=AVERAGE(SMALL(A3:A12,{1,2,3,4}))"

 

[AhoyNC]

Try:

[TABLE="width: 455"]
<colgroup><col width="455"></colgroup><tbody>[TR]
   [TD="width: 455"]=AVERAGE(SMALL(INDIRECT("A3"):INDIRECT("A12"),{1,2,3,4}))
[/TD]
 [/TR]
</tbody>[/TABLE]

 

[sfitzpat11]

Try:

[TABLE="width: 455"]
<tbody>[TR]
[TD="width: 455"]=AVERAGE(SMALL(INDIRECT("A3"):INDIRECT("A12"),{1,2,3,4}))[/TD]
[/TR]
</tbody>[/TABLE]

It worked! Thanks!

 

[AhoyNC]

You're welcome. Thanks for the feedback.