+ Reply to Thread
Results 1 to 4 of 4

How can i....

  1. #1
    newbie
    Guest

    How can i....

    OK how can i make a spreed sheet and do this: WE are having a contest that
    basically on a weekly,sometimes daily basis. You earn a certain amount of
    points depending on your guess's per question. Im looking for an easy way of
    doing this. Where as i can just plug in the points they got for that day and
    it automatically adds then to the pervious entry? Does this make sense to
    anyone LOL.


  2. #2
    newbie
    Guest

    RE: How can i....

    ok figured out the first part of my own uestion,GO ME lol. Anyways now onto
    another question(maybe i can solve it myself but im having trouble now) I
    want to take the reslut of Colum A(say its a 5) and Colum B(says its a 2) add
    those up and put the new result in colum A so its updated DOES this make any
    sense?

    "newbie" wrote:

    > OK how can i make a spreed sheet and do this: WE are having a contest that
    > basically on a weekly,sometimes daily basis. You earn a certain amount of
    > points depending on your guess's per question. Im looking for an easy way of
    > doing this. Where as i can just plug in the points they got for that day and
    > it automatically adds then to the pervious entry? Does this make sense to
    > anyone LOL.
    >


  3. #3
    JE McGimpsey
    Guest

    Re: How can i....

    Take a look here:

    http://www.mcgimpsey.com/excel/accumulator.html

    In article <[email protected]>,
    newbie <[email protected]> wrote:

    > ok figured out the first part of my own uestion,GO ME lol. Anyways now onto
    > another question(maybe i can solve it myself but im having trouble now) I
    > want to take the reslut of Colum A(say its a 5) and Colum B(says its a 2) add
    > those up and put the new result in colum A so its updated DOES this make any
    > sense?


  4. #4

    Re: How can i....

    How about where you have the sum in column A, you add the value from
    column b.

    Example:

    A1 through A6 have value and B1-B6 have values

    In B8 the formula could be =sum(B1:b6)
    In A8 the formula could be =sum(a1:a6)+B8

    This would make a8 have the sum of A1:B6

    Art


    newbie wrote:
    > OK how can i make a spreed sheet and do this: WE are having a contest that
    > basically on a weekly,sometimes daily basis. You earn a certain amount of
    > points depending on your guess's per question. Im looking for an easy way of
    > doing this. Where as i can just plug in the points they got for that day and
    > it automatically adds then to the pervious entry? Does this make sense to
    > anyone LOL.
    >



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1