title: Count visible rows from a filter result set that meet 3 criterea
body: <p>Not sure I'm doing this right, but I have a need to count only visible cells from a filter result that meet three criteria. I am trying the following formula: </p>
  
  <pre><code>=SUMPRODUCT(SUBTOTAL(3,OFFSET(F10,ROW(F10:F3153)-ROW(F10),0)),(F10:F3153="North America"),SUBTOTAL(3,OFFSET(G10,ROW(G10:G3153)-ROW(G10),0)),(G10:G3153="US Comm/CSI Market"),SUBTOTAL(3,OFFSET(K10,ROW(K10:K3153)-ROW(K10),0)),(K10:K3153="Won")+0)
  </code></pre>
  
  <p>, but though the syntax appears correct (Excel doesn't balk at the formula). it is not returning a correct result. What I need to do, is sort through a filter result set, and count the number of resulting visible rows that meet three criteria in different columns in the same row. If all three are met, it counts it. HELP?</p>