Sumproduct and frequency match with additional criteria

[RodneyC]

I'm using this formula to count the unique entries in column E.

=SUMPRODUCT(--(FREQUENCY(MATCH(AdcelData!$E$3:$E$794,AdcelData!$E$3:$E$794,0),ROW(AdcelData!$E$3:$E$794)-ROW($B$3)+1)>0))

It works, but it's just the first step to get me to where I really need to be. For reference, the formula above currently produces a result of 205.

I need the formula to also look in $T$3:$T$794 for any values greater than 0. So rather than looking at all values in E and producing the result (in this case 205) it should only count unique values in E where the value in T is greater than 0. In this case the number would be significantly less than 205.

Thanks in advance

 

[AhoyNC]

Try:
=SUMPRODUCT(--(FREQUENCY(IF(AdcelData!$T$3:$T$794>0,MATCH(AdcelData!$E$3:$E$794,AdcelData!$E$3:$E$794,0)),ROW(AdcelData!$E$3:$E$794)-ROW($B$3)+1)>0))

 

[RodneyC]

Try:
=SUMPRODUCT(--(FREQUENCY(IF(AdcelData!$T$3:$T$794>0,MATCH(AdcelData!$E$3:$E$794,AdcelData!$E$3:$E$794,0)),ROW(AdcelData!$E$3:$E$794)-ROW($B$3)+1)>0))

Awesome, that worked. Thank you

 

[AhoyNC]

You're welcome. Thanks for the feed back.