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

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk


"Big Trev" <(E-Mail Removed)> wrote in message
news:F9538ABD-EC2B-40D2-A4E5-(E-Mail Removed)...
>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
>
> (E-Mail Removed)
> Replace @mailinator.com with @tiscali.co.uk
>
>
> "Big Trev" <(E-Mail Removed)> wrote in message
> news:F9538ABD-EC2B-40D2-A4E5-(E-Mail Removed)...
> >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

(E-Mail Removed)
Replace @mailinator.com with @tiscali.co.uk


"Big Trev" <(E-Mail Removed)> wrote in message
news2C9EE0F-17DA-4A3A-9CFB-(E-Mail Removed)...
> 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
>>
>> (E-Mail Removed)
>> Replace @mailinator.com with @tiscali.co.uk
>>
>>
>> "Big Trev" <(E-Mail Removed)> wrote in message
>> news:F9538ABD-EC2B-40D2-A4E5-(E-Mail Removed)...
>> >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
>
> (E-Mail Removed)
> Replace @mailinator.com with @tiscali.co.uk
>
>
> "Big Trev" <(E-Mail Removed)> wrote in message
> news2C9EE0F-17DA-4A3A-9CFB-(E-Mail Removed)...
> > 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
> >>
> >> (E-Mail Removed)
> >> Replace @mailinator.com with @tiscali.co.uk
> >>
> >>
> >> "Big Trev" <(E-Mail Removed)> wrote in message
> >> news:F9538ABD-EC2B-40D2-A4E5-(E-Mail Removed)...
> >> >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.
> >> >
> >>
> >>
> >>
> >
>
>
>