Ok, thank you; this is working but would also like to extend formula to say
if I4=I6 then do not enter anything.in J5
I know it is not excatly what you sent me but your suggestion gave me a jump
start on the thinking.

A B C D E F G H I J
1 TEAM Game 1 Game 2 Game 3 Game 4 Game 5 Game 6 Game 7 Series Winner
2 Oct,24th Oct,25th Oct,27th Oct,28th Oct,29th Oct,31st Nov,1st
3
4 Philadelphia Phillies 1 0 0 0 0 0 0 1
5 1 0 0 0 0 0 0 Philadelphia Phillies
6 Team B 0 0 0 0 0 0 0 0
7 0 0 0 0 0 0 0



B5 says =IF(B5B7,1,0) then I hid the results by using white font
B7 says =IF(B7B5,1,0) then I hid the results by using white font

I4 says =SUM(B5:H5)
I6 says =SUM(B7:H7)

J5 says =IF(I4I6,A4,A6)

Thank you
Hope I haven't broken any newsgroup protocols
Not advocating that the Phillies are going to win, just using their name for
spacing since it is the longest.