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
=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