I'm musing this formula
=COUNTA(UNIQUE(Data4Adcel!D2:D344))
and it works fine but I need to add another criteria and can't seem to figure it out. I need it to only count the unique values in D where the values in R are greater than 0.
thanks in advance
=COUNTA(UNIQUE(Data4Adcel!D2:D344))
and it works fine but I need to add another criteria and can't seem to figure it out. I need it to only count the unique values in D where the values in R are greater than 0.
thanks in advance