how do I count the number of times text in column A matches text i

G

Guest

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

Bob Phillips

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

--

HTH

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

Guest

You can use:
{=SUM(IF(A1:A3=B1:B3,1,0))}

This is an array formula, so don't type in the {}, use Ctrl+Sift+Enter to
confirm(not just enter) the formula.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count if matching text 6
How do I count # of cells with same value other column? 4
With F1 value, look at A, if match or partial match return B 5
Count for text 4
Count values in column only if value of another column is true 4
Count if text meets given criteria 2
problem about count text 7
Convert Number to Text for Index/Match 1

Top