Copy that formula down the column for as many rows as you will likely have
entries in the Current column


"Anna / Ideal" wrote:

Ok, I received an answer to my earlier question If I have 2 columns, one
"Current" and one "MTD" and daily I am changing the "Current" column, can I
have the "MTD" column keep a running total. The answer was
=IF(B2="","",SUM($B$2:B2)). This will put what I enter in the "Current"
column in the "MTD" column, but it doesn't add the new entries to the "MTD"
column, it will just be the number I entered in the "Current" column. How
can I get the "MTD" column to add the new entries to itself each time I enter
a new number in "Current"?