Jerry,

I just corrected one small problem I guess I am not to useless.


#2) When I go to each school and make them when their stage #1 game on sheet #1, it works correct on sheet2 by saying there are no future stage 2 games the rest of the year. However it still shows all of the schools stage 3 and stage 4 games even though they are N/A.
I fixed this
=SUMPRODUCT(--(Sheet1!$I$2:$I$600=$A2),--(Sheet1!$M$2:$M$600<>"N/A"))
Where $M$ is you had $K$

YAY!!!! I learned something.

Still got the problem I listed as number 1. This is a show stopper as of now. If I cant write results in the column I can make it a win or loose. Now I know I can write over the formula, however then I need to go back and re add it each time I do this. Makes it very difficult.

Matt