Getting "0" into cell if "0" is there

[Esradekan]

Hi brainiacs, your help once again if you please.

I have a workbook for sport, games listed on one worksheet and results
broken down to 'Team Sheets' from the results. I am using this
formula here to break down the results onto "team sheets":

=IF(SUMPRODUCT(--(HomeTeam=$B$2),--
(AwayTeam=A5),HomeScore)<1,"",SUMPRODUCT(--(HomeTeam=$B$2),--
(AwayTeam=A5),HomeScore))

Problem is, it wont put in a score of "0" when there is one and when I
change the <1 part of the formula to ="", it puts a '0' in every cell
until there is a positive number in the corresponding source cell.
(Did I explain that right??). Is there a remedy for the problem?

Hope someone can help.

TIA
Esra >(*-*)<

 

[Bob Phillips]

Maybe

=IF(NOT(ISNUMBER(MATCH($B$2,HomeTeam,0))),"",
SUMPRODUCT(--(HomeTeam<>""),--(HomeTeam=$B$2),--(AwayTeam=D5),HomeScore))

 

[Esradekan]

Maybe

=IF(NOT(ISNUMBER(MATCH($B$2,HomeTeam,0))),"",
SUMPRODUCT(--(HomeTeam<>""),--(HomeTeam=$B$2),--(AwayTeam=D5),HomeScore))

--

HTH









- Show quoted text -

Sorry, still shows a '0' in unplayed games on team sheet. Thanks for
the help though.

(

Esra

 

[Esradekan]

Maybe

=IF(NOT(ISNUMBER(MATCH($B$2,HomeTeam,0))),"",
SUMPRODUCT(--(HomeTeam<>""),--(HomeTeam=$B$2),--(AwayTeam=D5),HomeScore))

--

HTH









- Show quoted text -

Sorry, again, no, it doesnt seem to work.

Esra