How can i....

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top