Sum From Beginning of Column

[John Persico]

How do I create a formula that adds from the top of a column?
Here's the situation.

I have a column of numbers (with a header of "Pay").
To the right of that colum I want to keep a running total ("Yearly Total").
Every time I get paid, I'm going to enter the amount in the pay column and
then I want the Yearly Total column to automatically add it.
When I create a fomula (say =SUM(B2:B21)), and propigate it down, it doesn't
start at the top. In others words the next formula is =SUM(B3:B22). I want
it to be =SUM(B2:B22). And, if a value is not filled in on the Pay column I
want the Weekly Total to be blank. I only want it activate if there's a
value for Pay. I guess I would have to use a conditionally formula as well,
right?

 

[Sandy Mann]

Try:

=IF(B2="","",SUM($B$2:B2))

Is there an echo in here?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[T. Valko]

Here's another way that is more efficient if you're dealing with a large
range of cells (assumes the range to sum will be a contiguous block):

A2:An = pay amounts
B1 = column header = Yearly Total

Enter this formula in B2 and copy down as needed:

=IF(A2="","",SUM(B1,A2))

Biff