Sum with Autofilter?

  • Thread starter Thread starter Shaun Allan
  • Start date Start date
S

Shaun Allan

I have a spreadsheet with a few columns and column
totals. If I apply an autofulter and select a subset, the
sum total still shows the total of the entire column, not
just the subset. Can this be changed?
 
When using filters use Subtotal(9,A1:A100) << See Help for further details,
9 = to sum; 3 = to count, etc.....
 
=SUBTOTAL(9,A2:A1000)

where A2:A1000 is the total column range will only sum visible cells
 
Hi
have a look at the SUBTOTAL function. This should do what you're trying
to achieve
 
Back
Top