that certainly would not be very efficient. In fact it wouldn't even be correct.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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