Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
Take a look he
http://www.mcgimpsey.com/excel/accumulator.html In article , newbie 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
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|