OK,

I moved the summary out like you said and I redefined the summer
range. I also made sure the results range was formatted as number an
I deleted the contents that were not 1.

The program now compiles clean with the following results:

...............................W-Streak.....L-Streak
Season......Team A.........0..................1
................Team B.........0..................2
................Team C.........0..................2
................Team D.........2..................0

Team A is correct but B should be 1 win, C should be 3 losses, and
should be 3 wins.

We're making progress

--
Message posted from http://www.ExcelForum.com