Compare columns and count matches

[alisherz]

Is there a way to do the following in a formula?

How do I compare Column 1 and Column 2, and if there is the same text in both rows, count as "1."

Row 1 Column 1 has Snickers. Row 1 Column 2 has snickers. I would only count that as "1."
Row 2 has Aero and Snickers so Aero would have "1" and Snickers would have "1"
Row 3 has Smarties and a blank cell so Smarties would have "1" and Blank cell would have "1"
Row 4 has Blank and Kitkat, so Blank cell would have "1' and kitkat would have "1"

In total:

Snickers: 2
Aero: 1
Smarties: 1
Kitkat: 1
Blank: 2

[FDibbins]

Hi, welcome to the forum

For future reference, please review our rules regarding thread titles. I have changed your title for you - this time

Try something like this...
=countif(A:A,A1,B:B,B1)