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

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
0
dlan75
Asked:
dlan75
  • 3
  • 3
  • 2
  • +1
3 Solutions
 
Angelp1ayCommented:
You can use COUNTIFS:
=COUNTIFS($A$1:$A$17,"David",$B$1:$B$17,"C")

Open in new window

Solution.xlsx
0
 
Steven HarrisPresidentCommented:
COUNTIFS should work out.  Check the attached sheet.
EE-test.xlsx
0
 
NBVCCommented:
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
dlan75Author Commented:
Nice but how to make it work on a whole column? Not A1:A4 but $A:$A
0
 
Steven HarrisPresidentCommented:
Same principle applies:

=COUNTIFS(A:A, "Criteria1", B:B, "Criteria2")
0
 
dlan75Author Commented:
well this is what I thought but it is not working ...
0
 
NBVCCommented:
Make sure that the formula itself is not in column A or B...
0
 
dlan75Author Commented:
it is not ! found a temporary workaround but would be easier to be able to select the entire column
0
 
Steven HarrisPresidentCommented:
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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