How do I set up a cumulative column, without entering it manually

L

LG

I am setting up a cumulative column in excel and I'm having to enter it
manually. Is there a way to do this quickly without having to do it manually.
 
N

Niek Otten

Assume your data is in Column A.
In B1, enter: =A1
In B2, enter: =B1+A2
Fill down as far as you need

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
B

Bernie Deitrick

Pivot Tables.

HTH,
Bernie
MS Excel MVP


LG said:
I am setting up a cumulative column in excel and I'm having to enter it
manually. Is there a way to do this quickly without having to do it
Click to expand...
manually.
 
Top