I have A1 to L1 total 12 cells reserved to enter the monthly values. m1 will
have last 3 months =Average(a1:c1). I need avoid the shifting of reference
cells every month in the formula to calculate last 3 month Average. Any
alternative formula I can apply to auto calculate the Average amount based on
3 value filled cells from the left end of the row? I mean if I fill apr value
in D1, then same result from =Average (b1: d1) which should automatically
return in m1.
Thanks