i need a formula to count the amount of cells with the same number in the two
cells. at the moment im using =countif(range,"="&range) but when i use this
it counts the blank squares which i dont want it to. i cant enter text into
the boxes as i have other formulas using them cells. does anybody have and
ideas is there another formula or a modifyed version of my current one ????

Do you mean where 2 adjacent cells are equal?

Try this:

=SUMPRODUCT(--(A1:A5<""),--(B1:B5<""),--(A1:A5=B1:B5))

Biff

"Bishop8910" wrote in message
...
i need a formula to count the amount of cells with the same number in the
two
cells. at the moment im using =countif(range,"="&range) but when i use
this
it counts the blank squares which i dont want it to. i cant enter text
into
the boxes as i have other formulas using them cells. does anybody have and
ideas is there another formula or a modifyed version of my current one
????

A B C
D E
1 score Group A
score
2 No Team vs Thames Pirates
3 Thames Pirates vs No Team
4 Stobswell Scary Monsters vs Bracknell wanna Bees
5 Bracknell wanna Bees vs Stobswell Scary
6 Hoof Hearted No Game
7

i want the formula to count the cells if the score in A2 is the same as in
E2. at the moment it counts the empty cells and i dont want it to. i need it
to count the cells which are 0-0 and any other score which is a draw.

"T. Valko" wrote:

Do you mean where 2 adjacent cells are equal?

Try this:

=SUMPRODUCT(--(A1:A5<""),--(B1:B5<""),--(A1:A5=B1:B5))

Biff

"Bishop8910" wrote in message
...
i need a formula to count the amount of cells with the same number in the
two
cells. at the moment im using =countif(range,"="&range) but when i use
this
it counts the blank squares which i dont want it to. i cant enter text
into
the boxes as i have other formulas using them cells. does anybody have and
ideas is there another formula or a modifyed version of my current one
????

Just change the range references:

=SUMPRODUCT(--(A2:A7<""),--(E2:E7<""),--(A2:A7=E2:E7))

Biff

"Bishop8910" wrote in message
...


A B C
D E
1 score Group A
score
2 No Team vs Thames Pirates
3 Thames Pirates vs No Team
4 Stobswell Scary Monsters vs Bracknell wanna Bees
5 Bracknell wanna Bees vs Stobswell Scary
6 Hoof Hearted No Game
7

i want the formula to count the cells if the score in A2 is the same as in
E2. at the moment it counts the empty cells and i dont want it to. i need
it
to count the cells which are 0-0 and any other score which is a draw.

"T. Valko" wrote:

Do you mean where 2 adjacent cells are equal?

Try this:

=SUMPRODUCT(--(A1:A5<""),--(B1:B5<""),--(A1:A5=B1:B5))

Biff

"Bishop8910" wrote in message
...
i need a formula to count the amount of cells with the same number in
the
two
cells. at the moment im using =countif(range,"="&range) but when i use
this
it counts the blank squares which i dont want it to. i cant enter text
into
the boxes as i have other formulas using them cells. does anybody have
and
ideas is there another formula or a modifyed version of my current one
????

Of course if both cells are equal you only really need to check that one is
not blank so this formula would suffice

=SUMPRODUCT(--(A2:A7<""),--(A2:A7=E2:E7))

"T. Valko" wrote:

Just change the range references:

=SUMPRODUCT(--(A2:A7<""),--(E2:E7<""),--(A2:A7=E2:E7))

Biff

"Bishop8910" wrote in message
...


A B C
D E
1 score Group A
score
2 No Team vs Thames Pirates
3 Thames Pirates vs No Team
4 Stobswell Scary Monsters vs Bracknell wanna Bees
5 Bracknell wanna Bees vs Stobswell Scary
6 Hoof Hearted No Game
7

i want the formula to count the cells if the score in A2 is the same as in
E2. at the moment it counts the empty cells and i dont want it to. i need
it
to count the cells which are 0-0 and any other score which is a draw.

"T. Valko" wrote:

Do you mean where 2 adjacent cells are equal?

Try this:

=SUMPRODUCT(--(A1:A5<""),--(B1:B5<""),--(A1:A5=B1:B5))

Biff

"Bishop8910" wrote in message
...
i need a formula to count the amount of cells with the same number in
the
two
cells. at the moment im using =countif(range,"="&range) but when i use
this
it counts the blank squares which i dont want it to. i cant enter text
into
the boxes as i have other formulas using them cells. does anybody have
and
ideas is there another formula or a modifyed version of my current one
????

if both cells are equal you only really need to check that one is
not blank

Yeah, you're right!

Biff

"daddylonglegs" wrote in message
...
Of course if both cells are equal you only really need to check that one
is
not blank so this formula would suffice

=SUMPRODUCT(--(A2:A7<""),--(A2:A7=E2:E7))

"T. Valko" wrote:

Just change the range references:

=SUMPRODUCT(--(A2:A7<""),--(E2:E7<""),--(A2:A7=E2:E7))

Biff

"Bishop8910" wrote in message
...


A B C
D E
1 score Group A
score
2 No Team vs Thames
Pirates
3 Thames Pirates vs No Team
4 Stobswell Scary Monsters vs Bracknell wanna Bees
5 Bracknell wanna Bees vs Stobswell Scary
6 Hoof Hearted No Game
7

i want the formula to count the cells if the score in A2 is the same as
in
E2. at the moment it counts the empty cells and i dont want it to. i
need
it
to count the cells which are 0-0 and any other score which is a draw.

"T. Valko" wrote:

Do you mean where 2 adjacent cells are equal?

Try this:

=SUMPRODUCT(--(A1:A5<""),--(B1:B5<""),--(A1:A5=B1:B5))

Biff

"Bishop8910" wrote in message
...
i need a formula to count the amount of cells with the same number in
the
two
cells. at the moment im using =countif(range,"="&range) but when i
use
this
it counts the blank squares which i dont want it to. i cant enter
text
into
the boxes as i have other formulas using them cells. does anybody
have
and
ideas is there another formula or a modifyed version of my current
one
????