How do I apply a formula to a whole column, keeping one variable fixed?
- 2nd row is
- 3rd row is
- 4th row is
How can I achieve that?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
It's like getting running average, therefore I would like to suggest to use below shown formula.
Where Column & Row doesn't change while filling down.
it may be
Where Row is not changing.
As soon you fill it down Excel start getting average of
G58:G58 (Row 1) then
G58:G59 (Row 2)
and so to the 4th Row (H61) is
Since absolute reference (using $ sigh) has been used with
G58, works as fixed variable.
If you use formula
=AVERAGE($G$58:G59) as I've tried in
I58, will works like,
G58:G59 (Row 1)
G58:G60 (Row 2)
G58:G61 (Row 3)
gets Average of 1, 2, 3, 4 is
as soon fill to the last row (I61),formula reads
G58:G62 , produces same value
G62 is Blank.
Adjust cell references in the formula as needed.