Help Need Formula for Calculator
"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
|