Count unique values in one column given multiple criteria for other columns

ok no problem. For what it's worth I don't think you could do this in a non VBA scenario without a helper column, trying to incorporate an array formula to extract the criteria matching records and then count the unique instances of items from within the results is bound to throw up a circular reference.

But there's some pretty smart people on here who continue to prove there's more than one way to crack a nut

good luck

See the attached.