With your current column being B starting with data in B2 and your MTD
column being C
In C2
=IF(B2="","",SUM($B$2:B2))
Copy down column C as far as you need.

--
Regards

Roger Govier


"Anna / Ideal" wrote in message
...
I have a spreadsheet where I have an "Current" column & a "MTD" column, can
I
have the MTD column keep a running total everytime I enter a new number in
the Current column?