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