Start Free Trial

asked on

Excel question

Hi Experts,

Something that should be simple but I am struggling with :-)

I have in column A a list of names
I have in column B another list of other names

I want to count how many times the same names appear in column B when it matches a name in column A

added an excel in order to clarify

Hope that is clear enough

Thx in advance !
David
test.xlsx

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

Nice but how to make it work on a whole column? Not A1:A4 but $A:$A

Same principle applies:

=COUNTIFS(A:A, "Criteria1", B:B, "Criteria2")

ASKER

well this is what I thought but it is not working ...

Make sure that the formula itself is not in column A or B...

ASKER

it is not ! found a temporary workaround but would be easier to be able to select the entire column

found a temporary workaround

Such as?

would be easier to be able to select the entire column

We provided that solution:

=COUNTIFS(A:A, "Criteria1", B:B, "Criteria2")