Formula Help!!!!

B

Bishop8910

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 ????
 
T

T. Valko

Do you mean where 2 adjacent cells are equal?

Try this:

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

Biff
 
B

Bishop8910

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

T. Valko

Just change the range references:

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

Biff
 
D

daddylonglegs

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))
 
Top