E
Esradekan
Problem still exists, but thanks to Bob for his effort, so posting
again.
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.
again.
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.