View Single Post
  #10   Report Post  
Biff
 
Posts: n/a
Default

Nope, sorry Dave, that doesnt work either.

Never mind, I will put up with it the way it is, thanks for trying.


Oh well!

Biff

"Biff" wrote in message
...
Hi!

If you'd like to, you can send me your file and I'll take a look. I'm at:

xl "can" help at comcast period net

Get rid of the quoted stuff and change the obvious.

Biff

"Sheila" wrote in message
...
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",yourformulahe re)


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