Forum Discussion
Pappy57
May 07, 2023Copper Contributor
Excel
Self taught older user,
I am stuck with a formula, trying to increase each comumn by a set value to keep a running total
Example
I am trying to add column A to column B, then column A to column C, then column A to column D so on and so on
Thanks,
Peter
$ 32.58 | $ 32.58 | $ 65.16 | $ 97.73 | $ 130.31 |
- Riny_van_EekelenPlatinum Contributor
With 32.58 in A1, enter =A1 in B1. Then in C1 enter:
=B1+$A1 and drag that formula to the right.
Alternatively, enter this formula in B1 and copy it across:
=$A1*(COLUMN()-1)