ExcelBanter - Count if two arguments met

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count if two arguments met (https://www.excelbanter.com/excel-discussion-misc-queries/153673-count-if-two-arguments-met.html)

Count if two arguments met

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

Count if two arguments met

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