Hi,
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 !
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 !