Type the following in cell b2

= sum(a:a) + b1


--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"catnohat" wrote:


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