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.
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.
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.
"Sheila" wrote:
> 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.
=sumproduct(--(A1:A100=B1:B100))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Sheila" <[email protected]> wrote in message
news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks