One way:

=SUMPRODUCT(--(A1:A25=B1:B25))

Extend the range as far as you need--but don't use the whole column.

=sumproduct() likes to work with numbers. The -- converts the true/falses to
1/0's.

tamato43 wrote:

I'd like to build a formula that states Countif the Text on cell equals the
same text on cell B.

I'm sure its an easy one.

--

Dave Peterson