Excel

[Pappy57]

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

[#2]

@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)