Good Morning,

I need a formula where it counts the top 3 based on "Eindscore" in column L but only from the "Categorie" found in F.

So I think a combination of Query, Sort and If would work but I am open to any ideas.

The Category is ever so changing; While now F27 is Color, it could be something else, so that should be taken into account as well.

Example worksheet:

CodePudding user response：

Can try SORTN() like-

=SORTN(FILTER(C2:C11,B2:B11="Color"),3,,1,0)