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