Try this for a non-volatile suggestion:
=IF(A1,SUM($A$1:A1),"")
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Jdog" wrote in message
...
CELL A1 has a number CELL B1 is the total (A1). As I add a number in
CELL A2 I want CELL B2 to be the running total. Then I add a number to
CELL A3 and I want B3 to be the total and etc. I don't want the cells
in B to have any number in them untill I add something in column A.
Please help. THANKS!!
--
Jdog
------------------------------------------------------------------------
Jdog's Profile:
http://www.excelforum.com/member.php...o&userid=28433
View this thread:
http://www.excelforum.com/showthread...hreadid=480321