See my suggestion in your original thread.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Anna / Ideal" wrote in message
...
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"?