Count unique distinct values based on a condition

[mehidy1437]

Hi, I got this here,

=SUM(IF("Jennifer"=$B$5:$B$26,1/(COUNTIFS($B$5:$B$26,"Jennifer",$C$5:$C$26,$C$5:$C$26)),0))

Is it possible to amend this formula without CSE to get the same result?

 

[Domenic]

Try...

=SUMPRODUCT(($B$5:$B$26="Jennifer")/(COUNTIFS($B$5:$B$26,"Jennifer",$C$5:$C$26,$C$5:$C$26)+($B$5:$B$26<>"Jennifer")))

Hope this helps!

 

[mehidy1437]

Many thanks, it's perfect.