=sumproduct(--(A1:A100=B1:B100))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sheila" wrote in message
...
I'm trying to count the number of times text in one column, say, A matches
text in another column, say, B. So, if A1=B1, count = 1, then if A2=B2,
count = 2, for the whole of both columns.