Change Sum when Filter Applied

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

How do you change the bacic formula; =sum(h3:h100) to
tally only the quantities visible in filtered rows rather
than all the rows. I recall adding a $9 or something
similar to the formula to acheive this but I've tried
every pemuation without luck.
 
Back
Top