title: How do I only count visible rows when using the COUNTIFS function?
body: <p>I've been using Excel's COUNTIFS function to count the number of rows in a table that meet certain criteria, E.g:</p>
  
  <pre><code>=COUNTIFS(Table1[Result],"Fail", Table1[Comments], "")
  </code></pre>
  
  <p>Now I want to modify this expression so that it only counts rows in Table1 that are visible. (I.E. Not filtered out.) How can I accomplish this?</p>