View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph
 
Posts: n/a
Default 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