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. |
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. |
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? |
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. |
All times are GMT +1. The time now is 12:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com