Formula could be like if the cell youre looking at is in the STAT 1 Column PLUS the name in Column A matches, it adds it, if not it moves on. SO something like Tab 1, Cell B2 is looking for STAT 1 for CHAD. Other wise you need a formula inyour fields in Tab 1 that references tab two when the name matches and the stat matches. If you want to update the cell every time you add a game score. So with the above now looking proper: On Tab 1, Stat 1 for chad is 'x'. Then tab B would need to look like this: BLANK

If on tab 2, you kept EVERY NAME and STAT in the same naming conventions and order, it can be done with a bit of big code. If it's just you manually entering (or copy-pasting what's being generated by a sim league engine, for example - I've come close to getting corsi data once, but the league folded before I could test it) the data in the games tab, then just having it spit out a summary shouldn't be too bad, especially if you know your players in the rosters tab ahead of time.ĮDIT: Basically, there are lots of ways to go about this, but most depend purely on how the Games tab will look like. I can't take a look at the example you provided right now (can later tonight though), but if that gives an idea of how you would format the games stats page, then I can take a look and help out in a better way. Game being played / Goal by / Assist 1 / Assist 2Īnd then make use of =COUNTIF in your roster tab to calculate the totals. One is the stuff that Daft-Funk is showing.Īnother would just be similar to the 'Play-By-Play' section of his link, where you could do (I am no Ace formatter): To add to what daft-funk is saying, it depends on how you want to format games tab. He was the longest-tenured Denver athlete and won the Stanley Cup in 2022.Ĭlick here for all 32 NHL Subreddits Division r/hockey stands with BIPOC and LGBTQIA+ NHLġ) - And just like that, Oscar Klefbom becomes the first Edmonton Oiler to play his full career with the club.ģ) - Thank you Joel Edmundson! Good luck in Washington!Ĥ) - Erik Johnson signs with Buffalo for one-year, $3.25 million.

Read the full posting rules here and what we ban for which includes code of conduct guidelines.

Memes, advice animals, and low-content posts will be removed on sight (click for examples).

Racist, ethnic, sexist or homophobic slurs/remarks of any kind will lead to a ban.

Nhl 17 roster spreadsheet