Hello
Here is my problem, I want to know the number of "x" I made in the entire column A in the cell A100
Exemple #1 if a1 = x , a5 = x, a 7 = X THEN a100 = 3
Exemple #2 if a1 = X , a5 = x, a 7 = X, a11 = x , a15 = x THEN a100 = 5
Exemple #2 if a1 = X THEN a100 = 1
I want to this whit a formula not with VB
Bookmarks