Try this:

=SUMPRODUCT(--(A1:A100="LPA"),--(B1:B100="Referrals"))

HTH,
Elkar


"Not Excelerated" wrote:

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