Countifs (duplicates counted ones)

[taxx411]

I have 3 columns

Full Name, Status, Source

Need a count ifs function to count my leads without duplicating in column A (names)

Existing Formula: =COUNTIFS(G:G,"*Open - Lead*",J:J,"Opcity")

Any ideas on how I can fix this?

 

[taxx411]

=IFERROR(ROWS(UNIQUE(FILTER($B$5:$B$100,($G$5:$G$100="open - lead")*($J$5:$J$100="David Yakubov")))),0)

Thank you but is there a way to tell excel any variation of Open - Lead. Some are Open - Lead (12/21)

 

[Fluff]

Yup, you can use

=IFERROR(ROWS(UNIQUE(FILTER($B$5:$B$100,(ISNUMBER(SEARCH("open - lead",$G$5:$G$100)))*($J$5:$J$100="zillow")))),0)

 

[taxx411]

Yup, you can use

=IFERROR(ROWS(UNIQUE(FILTER($B$5:$B$100,(ISNUMBER(SEARCH("open - lead",$G$5:$G$100)))*($J$5:$J$100="zillow")))),0)

You nailed it. I would not have ever figured this out. thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.