Hi Vince,

You could try using a formula in column D.

=IF(B2="","",D1+B2)

Francis J Hayes (The Excel Addict)
http://www.TheExcelAddict.com



"Vince" wrote:

I have a column designated as "Year-To-Date", and like to enter a formula so
that every time I enter a value in a cell in the same row (for instance B2),
it can then add that value to the current value in the Year-To-Date cell (for
instance D2) and give me a total Year-To_Date?? Any help appreciated.