I need to modify this formula:
=COUNTIF(Data4Adcel!$R:$R,">0") so that it only counts unique values in Data4Adcel!$D:$D where Data4Adcel!$R:$R,">0"
Said another way, in column D, there may be 7 entries that say purple and 5 of them have values in R >0 and there may be 5 values in column D that say orange and 4 of them have values in R >0. the formula would show a result of 2. FYI, Column D could have hundreds of different values.
Thank you in advance
=COUNTIF(Data4Adcel!$R:$R,">0") so that it only counts unique values in Data4Adcel!$D:$D where Data4Adcel!$R:$R,">0"
Said another way, in column D, there may be 7 entries that say purple and 5 of them have values in R >0 and there may be 5 values in column D that say orange and 4 of them have values in R >0. the formula would show a result of 2. FYI, Column D could have hundreds of different values.
Thank you in advance