Tell me more ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.
up vote 3 down vote favorite

I have a little basketball stats sheet, and a cell that has a total of a specific player's statistic they have accumulated throughout the season. But there is no way I know of to update this cell without tediously getting out a calculator and adding together the old total and the statistic in their most recent game to reinput the new total.

How can I make my spreadsheet automate the calculation/reinput?

share|improve this question

1 Answer

up vote 0 down vote

In the schedule sheet you could edit the following formula, each time you enter a new value like this:

B2=5+6+4
share|improve this answer
I mean on the Roster/Stats sheet. But that could work there too, though it's not the most intuitive solution. I must say I never really thought about doing it that way, certainly better than my current method. Is there a formula/script/shortcut that can make it so I just highlight the cell, type a value in, and it adds/updates the total all in 1 motion? Or maybe a new row where I type the most recent game statistic(s) in and it adds/updates it to the total(s)? Appreciate the help! – ArcaneGamer92 Nov 22 '12 at 8:59
Using a script is a whole new ball game.....You could also keeo track of all data per date, make a summation and reference to that summation. The script way, doesn't give insight on individual stats. – Jacob Jan Tuinstra Nov 22 '12 at 9:10
@ArcaneGamer92 I've created a UI for you to input data to the scores. Are you interested? – Jacob Jan Tuinstra Dec 25 '12 at 22:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.