• Status: Solved
• Priority: Medium
• Security: Public
• Views: 247

# 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

David
test.xlsx
0
dlan75
• 3
• 3
• 2
• +1
3 Solutions

Commented:
You can use COUNTIFS:
``````=COUNTIFS(\$A\$1:\$A\$17,"David",\$B\$1:\$B\$17,"C")
``````
Solution.xlsx
0

PresidentCommented:
COUNTIFS should work out.  Check the attached sheet.
EE-test.xlsx
0

Commented:
If you list David and Robert in A25:A26 and list C and D in B24:C24, then use formula:

=COUNTIFS(\$A\$1:\$A\$17,\$A25,\$B\$1:\$B\$17,B\$24)

copied to next column and down.

Alternatively, You can also add headers to the list and create a Pivot Table that will do the same summary quicker.
test-3.xlsx
0

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

PresidentCommented:
Same principle applies:

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

Author Commented:
well this is what I thought but it is not working ...
0

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

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

PresidentCommented:
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")
0

## Featured Post

• 3
• 3
• 2
• +1
Tackle projects and never again get stuck behind a technical roadblock.