I have a workbook that shows scores from games during the year and a
sheet for each team that shows their respective home and away scores,
taken from the main list of games played.

the formula i am using to put these teams game scores on their
respective sheet is as follows:

{=(SUMPRODUCT(--(HomeTeam=$C$2)*(--(AwayTeam=B5)*(HomeScore)))}

&

{=(SUMPRODUCT(--(HomeTeam=$C$2)*(--(AwayTeam=B5)*(AwayScore)))}

This shows the home team and the away teams score and it is adapted
for the return game.

This is an array formula and it uses 4 specified arrays,HomeTeam,
AwayTeam and AwayScore.

My problem is this. Without changing the summary sheet to NOT show
zero values, EVERY game until played shows as 0 - 0. Doesnt allow for
true records until seasons end. Now, is there an adaption of this
array formula to show NOTHING in the cells until the game is played?

TIA

Sheila.