In This Case, Getting the Grand Total Correct for Each Row Required SUMX
It’s that time of year again…
…when my love of spreadsheets actually translates into a love of sports. Yes, it’s Compulsive Data Crunching Disease season, AKA Fantasy Football Season.
Fantasy football is a game in which the contestants assemble “portfolios” of NFL players in the same manner that you might build a portfolio of stocks and bonds. Then your portfolio (we call it a “team”) performs well if the real-life NFL players perform well, and poorly if not. The one difference between this and the stock market is that no two “portfolios” can contain the same NFL player – so if I get Peyton Manning, the other contestants in my league (typically 8-12 people) cannot have him.
I’m participating in a new form of league this year, one in which the contestants get to keep some of the players from prior years. (In most fantasy football leagues, you start each year from a clean slate).
We’re going to be picking our players this weekend at an “auction” or “draft,” and naturally, I want to scout my opponents ahead of time. Muhaha.
So, what do my opponents need?
A valid portfolio consists of: