Change the range of cell with given value

Question

Can anyone solve this problem

I need to find the simple moving average with a condition if J1 is 9 then it has to calculate from E2:E10 and put in G10

If the given value is 15 then the result has to for 15 periods SMA

While changing the SMA value then the range has to change and given SMA has to result

score 1 · Answer 1 · answered Aug 26 '20 at 17:09

1

You can use following formula:

=IF(ROW()=$J$1+1,AVERAGE($A$2:INDEX(A:A,$J$1+1)),"")

answered Aug 26 '20 at 17:09

basic

It's working But I need SMA continuously throughout the row – dgnk Aug 27 '20 at 12:45
In the example, you asked SMA for the column. Add another example with the desired result. – basic Aug 27 '20 at 13:46

1 Answers1