title: How to get visible-only sum of items that have been auto-filtered with a criteria?
body: <p>I have been using <code>=SUMPRODUCT(SUBTOTAL(9,OFFSET(I2,ROW(I2:I61)-ROW(I2),0)),(B2:B61=B91)+0)</code> in excel to get the sum but only if the row is visible and where a criteria in another cell matches and it worked fine but when i use it in <a href="https://docs.google.com/spreadsheets/d/1v2cUElA1iarh1Wm6Vyj54SyvKkG81UlaNYR50gv9JuA/edit?usp=sharing" rel="nofollow">google</a> sheets i get an <code>mismatched range size</code> error.</p>
  
  <p>What did i do wrong or rather how can i get it working?</p>