Duke: Thank you for your response. My problem is this: When I used this
formula and I typed in a number, that number was shown in the MTD column.
Perfect. Except when I enter a new number in the Current column, it just put
that same number in the MTD column.

Say like this:

Current MTD
Shingle loads 5 10
Job set ups 4 8
Shingle complete 6 15

So, the next day I would just put a new number in the current column and
then I am manually changing the MTD column. I would like it to automatically
add the new number itself in the MTD column.

"Duke Carey" wrote:

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"?