1. there is no need to array enter sumproduct formulas
2. You should use either unary minuses or multiply the arrays, not both, so
either


=SUMPRODUCT(--(HomeTeam=$C$2),--(AwayTeam=B5),HomeScore)

or


=SUMPRODUCT((HomeTeam=$C$2)*(AwayTeam=B5)*(HomeSco re))


what is the result you desire and what is the result you get, or rather hoe
do you determine a game has been played?

--
Regards,

Peo Sjoblom


"Sheila" wrote in message
...
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.