Hi!

Enter this formula in B2 and copy down as needed:

=IF(A2="","",SUM(B$1,A$2:A2))

Biff

"catnohat" wrote in
message ...

Hi:)

What I want to do is add a2 to b1 and have the total show in b2.
I also want it set up so that when a number is entered in the a column
it is automaticaly added to the previous b colum cell and then totaled
across from that a cell.
thank you for your help


+-------------------------------------------------------------------+
|Filename: excel test 1.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4445 |
+-------------------------------------------------------------------+

--
catnohat
------------------------------------------------------------------------
catnohat's Profile:
http://www.excelforum.com/member.php...o&userid=32377
View this thread: http://www.excelforum.com/showthread...hreadid=521394