Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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