Forum Discussion
Need Formulas For Stats
I think I did this correctly?
Well, yes...but. You should take it down and post only a copy of the first sheet if you want to continue getting help. There's a sheet in there that contains real names and phone numbers; that should not have been posted.
That said, I'm attaching a spreadsheet [the one you shared is read-only, so I had to copy to my own computer] that shows one way to accomplish what you're trying to do. It's probably not the most elegant solution, but it'll work (after you follow the pattern out for the remaining weeks). What you'll see is that I added a column for each week that simply (and automatically) notes whether it was. a win, loss, or draw. And then the formulas back at the far left, where you summarize, call on those "helper columns" rather than trying to determine win or loss AND add all in one fell swoop. As I said, probably not the most elegant, but then, I'd have approached the whole thing in a different way (which still may not have been the most elegant).
I also added some conditional formatting to highlight teams with winning or losing season records. So the final summary columns look like this.
Oh yes, the last part of your original question:
Also we have sportsmanship rating and each week a team submits a score out of 10 ie.(7/10)... This I have recorded in E3. Is there a way to have it automatically add the new number to the existing one entered? So... if the cell currently reads 20, i just select it and type 7, and it autosums to 27.
I've always found it helps me keep my brain functioning when I do those autosums (especially when we're talking of max two-digit numbers) in the aforementioned brain. And I suspect it's a lot faster than any VBA routine or macro that otherwise would have to be written. An alternative, if you think it necessary to keep track of the individual weekly submissions, would be to actually keep in the cell a running total. So although the cell might be showing, say, 30, if you put your cursor on the cell, you could read =7+8+6+9... Personally, I'd go with doing the math in my head and just entering the new total, overwriting whatever was there.
Have fun coaching!!
Thanks again
- You are very welcome