Forum Discussion

Pappy57's avatar
Pappy57
Copper Contributor
May 07, 2023

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_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    Pappy57 

    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)

Resources