# Solved: Excel: Adding Numbers in a Column on a Daily Basis?

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

#### halcour

Hello group,

I wasn't quite sure how to word the subject line. I would like to be able to add a number to column A everyday and have the cumulative sum of column A show in column B in the adjacent cell so I can chart it. So it would look something like this:

1 1
1 2
1 3
2 5
-1 4

I think it's something to do w/the SUM function but I can't quite figure it out. Any help much appreciated.

Harold

#### bomb #21

If your list starts in A1, use =SUM(\$A\$1:A1) and copy down. For more info on using \$s, see Excel Help for "relative and absolute references".

Excellent!

Thanks much,
H

#### Zack Barresse

Why not just use =SUM(A:A) ??

#### bomb #21

firefytr said:
Why not just use =SUM(A:A) ??
Won't cut it for cumulative, buddy.

#### Zack Barresse

I see, I thought only the sum total was desired for a single instance. Gotcha.

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

As Seen On