I've been wondering how to use countif with numerical value.

I want to search in a Column the number of '1' so I'm doing Countif(Tableau[1].plage,1) which is working but the tricky thing is that sometimes there is 2 or 3 values in a cell (like '1, 2' or '2, 3' ...) so when I do the formula I get only the cells with just '1' not the ones with multiple values including 1.

So I tried doing multiples things :

Countif(Tableau[1].plage,"*"&1&"*")

Countif(Tableau[1].plage,"*1*")

But these formulas only count the cells with ONLY multiples values.

I can reach the result I want by doing Countif(Tableau[1].plage,1)+Countif(Tableau[1].plage,"*"&1&"*")

but I'm wondering if it's possible without 2 formulas.

Thanks for your help !