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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Applying formulas to filtered data 4
Sum If Visible 10
subtotal filter with growing range 2
SUM formula that resizes? 3
Filtered Statistics 2
sum number of columns based on variable value 4
make formula look at diff sheet 5
summing based on auto filter 2

Back
Top