I have the below formula which works correctly however I have duplicates in rows which I need it to deduct, any ideas what I can add to get it to do this without?



=SUM(COUNTIFS($A$28:$A$224,"Accepted",$C$28:$C$224 ,"Tier 1"))

So for example I have the below, the number I need to get to is 4 accepted tier 1 companies:

Accepted Mr Smith Tier 1 Company A
Accepted Mr Reynolds Tier 1 Company A
Accepted Miss Cole Tier 1 Company B
Accepted Mr x Tier 1 Company C
Accepted Mrs Y Tier 1 Company C
Accepted Mr Z Tier 1 Company D

Note I cannot just use the frequency count as I need it to look for specific things across a range of data.

Ive been racking my brains so anyone that can help with this would appreciate it!
Thanks :0)

How about use a helper column, so in E1 copied down...

=COUNTIFS($A$1:A1,A1,$C$1:C1,C1,$D$1 : D1,D1)

Now if F1 count the 1's for the unique...

=COUNTIF(E:E,1)

Moved to non-programming forum

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

This works thank you so much!

Happy to hear it helped you out and you're welcome.