title: Google Sheets Countif with multiple criteria
body: <p>In a Google Sheet  am trying to count the occurrences of a value (&quot;R&quot;) in a row (11) where the same column in a different row (4) has the value (&quot;Future&quot;) ie in how many columns do I have &quot;R&quot; and &quot;Future&quot;.<br>
  My current formula is
  =countifs(M11:BM11,&quot;R&quot;,M$4:BM$4,&quot;Future&quot;)</p>