Many people talk about "counting unique" when they really mean counting distinct items. Taken literally "counting unique" within this dataset:
banana
banana
apple
apple
apple
orange
would give a result of 1 (orange is the only unique item)
but I assume you want to count distinct, in which case the result is 3 for that example
Can you clarify exactly what you want to do in your scenario? - you seem to be using criteria like "*aging" and sheet3!G24
Are you trying to count distinct items but only when other criteria apply?
If you want to count distinct items in column Q where the criteria apply in the other two columns then is is probably the most efficient way to do that:
confirmed with CTRL+SHIFT+ENTER
Bookmarks