COUNTIF with 2 conditions

W

webmestre

I have a worksheet with 2 columns:
- The first column has different names (e.g. John Smith, Laura Le)
- The second column has Y (for yes) and N (for no) values

I'm using the following function to count how many times I have "John
Smith" in column 1:
=COUNTIF('Sheet1'!A1:A1000,"John Smith")

What would be the formula if I want to count how many time John Smith
has Y in column 2? In other words, I want to sort column 1 by names
and count how many times I have Y for each name.

Thank you

Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count occurrences when two conditions are met 1
COUNTIF with 2 conditions 6
Auto sum 2 adjacent row data into 3rd row? 1
Count of Engagements by Salesperson 1
COUNTIF 9
Lookup and count in the same formula 1
Counting Unique Entries 3
Count cells if next column has text 2

Top