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

E

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 >(*-*)<

B

#### Bob Phillips

Maybe

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

E

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

E

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