If you don't want to see the total in Column B for cells that are not yet filled
in Column B, I would suggest this revision to RD's formula.

=IF(A1="","",SUM(A$1:A1))


Gord Dibben MS Excel MVP

On Sat, 23 Feb 2008 16:52:05 -0800, "RagDyeR" wrote:

Correction:

=Sum(A$1:A1)
--

HTH,

RD
================================================= ====
Please keep all correspondence within the Group, so all may benefit!
================================================= ====

"RagDyeR" wrote in message
...
Since you only have 400 rows, enter this formula in B1:

=Sum($A1:A1)

Click back in B1 and hover the cursor over the little black square in the
lower right corner of the cell.

When the cursor changes from a fat white cross to a skinny black cross,
click and drag down to Row 400.

You don't have to type the formula into each individual cell.