To count unique values with one or more conditions, you can use a formula based on UNIQUE, LEN, and FILTER. In the example shown, the formula in H7 is:
To count unique values with one or more conditions, you can use a formula based on UNIQUE, LEN, and FILTER. In the example shown, the formula in H7 is: