How to add a constant value to a column in Excel

How to add a constant value to a column in Excel

Set up an equation in an empty cell that adds the first cell of the column + the cell holding the constant value, however the cell holding the constant value should be renamed with dollar signs using the following format:

For example cell "A1" should be renamed to "$A$1"

[sdgakatbk]

Excellent. Now I can continue with my home grown tweak of pitchers' fatigue in APBA baseball.

[blackwolf]

I have no idea what you showed me, but I followed and it worked

[ryanfindlay]

thank you why can't every video be like this

[itsjamal]

How to add the constant in its own column?

[dhaneshelectrical]

I want a formula for variable cell reference.
I am having a row of 100 number A1 to A100.
I am having a other row of 100 numbers in column B1 to B100
Now in Column C, I want to average A1 to A100 based on value on column B1 to B100
Suppose if $A$1:A10 = 50, and at that time B10>0, now for next averaging I want to use formula $A$11:A12, $A$11:A13, $A$11:A14 and so on.
Again if anytime, say $A$11:A20 = 100 and same time B20>0, I want to change average formula from next cell and it will become $A$21:A22, $A$21:A23, $A$21:A24 and so on
Pls guide