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


E

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

Advertisements

B

Bob Phillips

Maybe

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

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
 
Ad

Advertisements

E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top