Not exactly what I need - Example: Let's say I only have 1 row - Column A1
has ( 5 ) & Column B1 has ( 5 ) - I enter into A1 ( 3 ) and column B1
then adds it into what is already there and it then becomes ( 8 ) - I again
enter into A1 ( 6 ) and column B1 adds it it into what is already there and
it becomes ( 14 ) like a calculator.

"David Biddulph" wrote:

"Windsong1948" wrote in message
...
I need to enter into column 1 a number and have it automatically added to
column 2 like a calculator. I have a long list of items and as items are
delivered I want to
simply enter the qty and have it automatically added to the next column
for
a year to date total. Please help me if you can.

In B1 use the formula ==SUM(A$1:A1) and copy down.

If you want column B blank where you haven't yet put an entry in column A,
you could use
=IF(A1="","",SUM(A$1:A1))
--
David Biddulph