Thread: How can i....
View Single Post
  #4   Report Post  
 
Posts: n/a
Default

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.