title: Countifs with Or
body: <p>I have column like this</p>
  
  <pre><code>+------+-------------------------+-------------------------+
  | Year |         Status1         |         Status2         |
  +------+-------------------------+-------------------------+
  |    1 | [Blank]                 | Confirmed on YYYY.MM.DD |
  |    2 | Confirmed on YYYY.MM.DD | done on YYYY.MM.DD      |
  |    1 | Confirmed on YYYY.MM.DD | Confirmed on YYYY.MM.DD |
  |    2 | Attended on YYYY.MM.DD  | Confirmed on YYYY.MM.DD |
  |    1 | Attended on YYYY.MM.DD  | done on YYYY.MM.DD      |
  |    1 | done on YYYY.MM.DD      | done on YYYY.MM.DD      |
  |    2 | done on YYYY.MM.DD      | done on YYYY.MM.DD      |
  |    1 | Ready on YYYY.MM.DD     | Confirmed on YYYY.MM.DD |
  |    2 | Ready on YYYY.MM.DD     | Confirmed on YYYY.MM.DD |
  +------+-------------------------+-------------------------+
  </code></pre>
  
  <p>I need to count the total number of rows that both Status1 and Status2 are containing "Attended", "Done" or "Ready".</p>
  
  <p>Expected Result is </p>
  
  <pre><code>+------+-----+
  | Year | Sum |
  +------+-----+
  |    1 |   2 |
  |    2 |   1 |
  +------+-----+
  </code></pre>
  
  <p>I tried COUNTIFS and as there is not OR operator, if I brute force, then formula calculating sum of Year 1 becomes</p>
  
  <pre><code> =
  countifs(A:A, "=1",B:B, "=*attended*", C:C, "=*attended*")+
  countifs(A:A, "=1",B:B, "=*attended*", C:C, "=*done*")+
  countifs(A:A, "=1",B:B, "=*attended*", C:C, "=*ready*")+
  countifs(A:A, "=1",B:B, "=*done*", C:C, "=*attended*")+
  ..........
  </code></pre>
  
  <p>There will be 9 cases and if later I have another new cases, the formula will be terribly long. 
  Therefore, is there any simple solution to my question?</p>
  
  <p>I read this thread 
  <a href="https://stackoverflow.com/questions/21419578/google-spreadsheets-how-do-i-combine-countif-with-or">Google Spreadsheets: How do I combine COUNTIF with OR</a> but I am not sure how I can apply DCOUNT or COUNTIFS into this situation.</p>
  
  <p>Many thanks.</p>