Number of values above x in column B, for each unique value in adjacent column A.

Originally Posted by JBeaucaire

You should be using COUNTIFS() for this.... (not CountIf, COUNTIFS).

=COUNTIFS(A:A, "Y", B:B, ">20")

....etc.

Ah, beautiful. Thanks for this! Repped and marked as solved