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.

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


Replace @mailinator.com with @tiscali.co.uk


"Big Trev" wrote in message
...
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.

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" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"Big Trev" wrote in message
...
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.

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


Replace @mailinator.com with @tiscali.co.uk


"Big Trev" wrote in message
...
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" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"Big Trev" wrote in message
...
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.

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.

"Sandy Mann" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"Big Trev" wrote in message
...
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" wrote:

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


Replace @mailinator.com with @tiscali.co.uk


"Big Trev" wrote in message
...
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.