How can i....

[Guest]

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.

 

[Guest]

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?

 

[JE McGimpsey]

Take a look here:

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

 

[Art]

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