After playing around a bit with your file I found the maximum (on my PC using excel 2007) number of rows to be 138.

Limiting factor seems to be memory. Checking the different models I also found that using the “SUMPRODUCT” formula when calculating “QB”, “RB”, “WR”, “TE” and “Defense” made the model less robust as excel could only handle 130 rows before collapsing.

So even if the SUM setup for “QB”, “RB” and so forth don’t look so impressive it is the more “robust” solution to your problem as it can handle more rows.

If this solves your problem could you please mark your thread solved and if you like to give a rating to my answer click on the small star bottom left in my post.

Alf