Countif Text equals the same

T

tamato43

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.
 
D

Dave Peterson

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