I even laughed at your humour too, yes I know I said i want to put
NOTHING in the cell, but i just dont want the digit '0' in there.

sheila




On Sat, 14 May 2005 14:35:43 +1200, Sheila
wrote:

Sorry Dave, no that doesnt work.

Please see previous post titled "Summarising scores"

TIA

Sheila



On Fri, 13 May 2005 18:05:28 -0500, Dave Peterson
wrote:

=if(count(homescore)=0,"Nothing",yourformulahere )


Sheila wrote:

I am using Sumproduct

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

to put team scores on a team sheet, but still get a score of 0 - 0
when the game hasnt been played and no score is entered onto the
'schedule' sheet. This is not ideal. How can i have NOTHING go into
the cells when the game has not been played. These scores come from a
'schedule' sheet with all games for the year listed.

any help?

sheila
TIA