title: Excell : how many times a value OR another value appear in a column
body: <p>I have a column on Excel, I found out how to count how many times a value appears in it (ex: how many 1 in the column), but I can't find how to make it count how many times one OR another value appears in this column (ex: how many cells with the value 1 OR 2).
  Here is an example of my colum:</p>
  
  <p>A1  1;</p>
  
  <p>A2  1;2;</p>
  
  <p>A3  1;3;</p>
  
  <p>A4  2;</p>
  
  <p>A5  1;</p>
  
  <p>A6  2;3;</p>
  
  <p>A7  1;2;</p>
  
  <ul>
  <li><p>In this column, if I want to find how many cells with the number 1 there are, I would do : 
  =COUNTIF(A1:A7,"<em>1</em>")       and then the result would be : 5</p></li>
  <li><p>But if I want to find how many cells have the number 1 OR the number 2, I can't find how to do, but I know the result is 7 (because the all of these cells have or the number 1, or the number 2)
  The only way I found is to calculate the number of cells with the number 1 wich don't have the number 2, and to calculate the number of cells with the number 2 wich don't have the number 1, and add the sum of those to the number of cells with the value "<em>1;2</em>", wich gives me a long formula like: 
  =(COUNTIF(A1:A7,"<em>1</em>")-COUNTIFS(A1:A7,"<em>1</em>",A1:A7,"<em>2</em>"))+(COUNTIF(A1:A7,"<em>2</em>")-COUNTIFS(A1:A7,"<em>2</em>",A1:A7,"<em>1</em>"))+COUNTIF(A1:A7,"<em>1;2</em>")</p></li>
  </ul>
  
  <p>Any one has a simpler formula?
  Thank you so much if someone can resolve this!!</p>