Count if two arguments met

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top