SUM From Beginning of Column

J

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?
 
S

Stan Brown

Sun, 20 May 2007 16:18:03 -0400 from John Persico
When I create a fomula (say =SUM(B2:B21)), and propagate it down, it doesn't
start at the top.
Click to expand...

Make the starting reference absolute: B$2:B21. See "absolute and
relative references" in Help -- fantastically useful.
 
S

Stan Brown

Sun, 20 May 2007 16:18:03 -0400 from John Persico
How do I create a formula that adds from the top of a column?
Here's the situation.
Click to expand...

Please don't post the same article multiple times.

This isn't a chat room -- you need to allow much, much longer than
six minutes for a response.
 
Top