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.

"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

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

http://www.mcgimpsey.com/excel/accumulator.html

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Windsong1948" wrote in message
...
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

"Windsong1948" wrote in message
...

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

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.

To add to itself would be a circular reference, and these are to be avoided
like the plague.
--
David Biddulph