Count if two arguments met

  • Thread starter Not Excelerated
  • Start date
N

Not Excelerated

Hello and thanks in advance:

I'm attempting to create a formula to get a count if 2 conditions are met
from 2 separate columns of text data. I want to know how many occurrences
there are when both "LPA" in Column A and "Referrals" in Column B occur for
each row looked at. Here is an example where the result should be 3:

Column A Column B
1 LPA Referrals
2 NLPA Referrals
3 LPA Referrals
4 LPA Referrals
5 NLPA Referrals

Thanks!
Chris
 

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

calculating with weeks 1
List all tables, including document structure 0
Count occurrences when two conditions are met 1
Compare a column of substring with another column of strings and get count 2
Countifs with if and date range 2
Countif, IF condition is met 2
SUMIF Variations Problem 4
Consolidation Table from Different Excel Tabs with Different Format 1

Top