I have a table listing items in column 'A'. How do I keep a running total of
the individual items as they are entered. Below is an exemple of my table.

A B C D
Item Stock in Stock out Stock left

Nails 100 70 30
Clips 100 60 40

As the items are entered I wish the total in column D be kept up to date for
the individual item. Thank you.
--
ASU

The formula in column D would be =B3-C3, then copy the formula down the
length of the column
--
Kevin Backmann


"ASU" wrote:

I have a table listing items in column 'A'. How do I keep a running total of
the individual items as they are entered. Below is an exemple of my table.

A B C D
Item Stock in Stock out Stock left

Nails 100 70 30
Clips 100 60 40

As the items are entered I wish the total in column D be kept up to date for
the individual item. Thank you.
--
ASU

Thanks for getting so quick. What I was looking for is how do I keep a
running total of individual items. eg if I add more nails to the list it
would keep a running total of that item only. And if like wise with other
items. I hope thats clear!!!
--
ASU


"Kevin B" wrote:

The formula in column D would be =B3-C3, then copy the formula down the
length of the column
--
Kevin Backmann


"ASU" wrote:

I have a table listing items in column 'A'. How do I keep a running total of
the individual items as they are entered. Below is an exemple of my table.

A B C D
Item Stock in Stock out Stock left

Nails 100 70 30
Clips 100 60 40

As the items are entered I wish the total in column D be kept up to date for
the individual item. Thank you.
--
ASU