title: How to define a non continuous range in COUNTIF
body: <pre><code>   A    B   C
  
  1  Β        Β
  2  Β        Β
  3  Α        Α
  4  Α        Α
  5  Β        Β
  6  Α        Α
  7  Α        B
  8  Β        Β
  9  Β        Β
  10 Α        Α
  11 Β        A
  12 Α        Α
  13 Α        Α
  14 Β        Β
  15 Α        Α
  16 Β    ??  
  </code></pre>
  
  <p>In cell B16 I want to count how many "B"s (the value in A16) are in cells C1:C15 <em>and</em> A16. Then using some function I will put an "A" or "B" in cell C16. How can I give such a range in COUNTIF? The same formula must be used for every cell in column B.</p>