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.
I think I did this correctly?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.
