1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

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

Discussion in 'Business Applications' started by halcour, Feb 2, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. halcour

    halcour Thread Starter

    Joined:
    Mar 2, 2005
    Messages:
    510
    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
     
  2. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    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".
     
  3. halcour

    halcour Thread Starter

    Joined:
    Mar 2, 2005
    Messages:
    510
    Excellent!

    Thanks much,
    H
     
  4. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    Why not just use =SUM(A:A) ??
     
  5. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    Won't cut it for cumulative, buddy. ;)
     
  6. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,452
    I see, I thought only the sum total was desired for a single instance. Gotcha. :)
     
  7. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/540410

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice