Sum with Autofilter?

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?
 
J

JMay

When using filters use Subtotal(9,A1:A100) << See Help for further details,
9 = to sum; 3 = to count, etc.....
 
P

Peo Sjoblom

=SUBTOTAL(9,A2:A1000)

where A2:A1000 is the total column range will only sum visible cells
 
F

Frank Kabel

Hi
have a look at the SUBTOTAL function. This should do what you're trying
to achieve
 
Top