This video shows how to count unique values but only if a condition is met in another column. This shows how to use COUNTA, UNIQUE, and FILTER together which filters data from a range of cells but then list down unique values and finally to count all the values within the range or array.
