Counting unique clients during a specific period of time with other criteria

I would not recommend using entire column references in this sort of formula as it's calculation-intensive. you would be better off using named ranges or a table.

Originally Posted by JosephP

I would not recommend using entire column references in this sort of formula as it's calculation-intensive. you would be better off using named ranges or a table.

Agree on this.