Hi All.......
I have 23 rows in column AU that contains the string "Receipt Traveler Put
Away"
And, for those 23 rows, I have 22 unique TEXT strings in column K and one
duplicate.

I'm trying to count the unique TEXT strings in column K that have "Receipt
Traveler Put Away" in column AU.....answer would be 22

Using the following formula, I get 17.45111111......anybody see what's
wrong?.......or another way?

=SUMPRODUCT((K2:K1595<"")/COUNTIF(K2:K1595,K2:K1595&"")*(AU2:AU1595="Receipt
Traveler Put Away"))

TIA
Vaya con Dios,
Chuck, CABGx3