Anna
See my response to the posting you put in the other thread you started.
It is best to keep posting in the same thread on the same subject, rather
than starting a new one.

--
Regards

Roger Govier


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