Try:

=IF(A1="","",SUM(A1:OFFSET(A1,COUNT(A:A),0)))

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"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