Hi, I'm stumped on trying to find the right formula that will only count the first occurrence of a text. I'm using COUNTIFS and so there several criteria in several columns. However one column (E) includes the organization's name and I only want to count the first occurrence for each organization. I tried to count the original total with duplicates but then remove the duplicate occurences. Here is what I did:

=COUNTIFS($G$29:$G$105,"Domestic*",$J$29:$J$105,"Confirmed*",$H$29:$H$105,H18)-COUNTIFS($G$29:$G$105,"Domestic*",$J$29:$J$105,"Confirmed*",$H$29:$H$105,H18,$E$29:$E$105,$E$29:$E$105&"")

But it didn't work... I also tried variations of the SUMPRODUCT and SUM(IF...) without much luck.

Any suggestions?