How do I get 0 (zero) to register as a value as opposed to blank c

[Big Trev]

I am running a sports league championship with league tables. Not that it
matters that much but the sport is World 8-Ball Pool. I need to count the
number of games each player wins draws or looses which in general is not a
problem unless they loose without winning a frame. In this instance the
matchmscore card will have a 0 (zero) number of frames recorded in the
relevant cell, but when this happens I cannot detect the zero value as
opposed to a blank cell. What I need to do is enter a value in a collection
cell to count the value of 1 if a player scores 0 but ignore it if the value
of the cell is blank. At the moment I cannot detect a 0 value unless I put in
that 0=1 but that also picks up all blank cells and that is where I fail. can
you tell me how I ignore a blank cell but detect 0 as a distinct value.

 

[Sandy Mann]

Unless I am not understanding you, the COUNT() function will count all
number but ignore blanks.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Big Trev]

Perhaps I did not explain my problem clearly enough.

In 1 worksheet I have a fixture list where I enter the results, this acts as
a record so all can see each match score and who is yet to play. When I enter
a score in the cells, say 6-0, the value of the frame (either 6 or 0) is then
picked up on another worksheet where I collect data for each game for each
player. That value in turn is then detected by other cells and if above a
certain value (in this 4 or above) it will show a value of 1 in the column
marked "WINS", if the player scores 3 (i.e. the match is 3-3) then it will
show a value of 1 in the column marked "DRAWS", if the value is less than 3
then it will show a value of 1 in the column marked "LOST". My problem if
that if the score is 0 it does not pick it up and give the value of 1 in that
column. The 3 columns use the =IF(B3<3,.......... type of equation to
determine their values. But if the value is 0 my column for LOST does not
pick it up and record the value 1, I trust this explanation is clearer and
better explains my problem.

 

[Sandy Mann]

mmmm....

I'm still not certain that I understand what you want, (probably my fault),
but if you want to differentiate between <3 and a blank cell then use
something like:

=IF(AND(B3<3,B3<>""), ..........

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Big Trev]

I hope you don't mind but I have sent the query & workbook to your e-mail
direct for a better explanation of what I am trying to achieve. I thhink you
will see the problem more clearly then.

Regards.