=SUBTOTAL(9,K2:K5457) fails with AUTOFILTER

  • Thread starter Thread starter - Doug
  • Start date Start date
D

- Doug

I use SUBTOTAL with AUTOFILTER to give totals of (only)
the "filtered" data. Sometimes the subtotals disappear,
sometimes they total an inaccurate amount, sometines it
works. What am I doing wrong. Please advise, thanks, -
Doug
 
If it disappears then you probably filter on the particular row
that houses the formula. I doubt it would be inaccurate.
Could you explain a bit more?
 
ref: Windows 2000, Office 2000

I am summing columns. When I filter the sheet on a column,
I sometimes loose the subtotal. I will also sometimes get
an inaccurate subtotal. I will work with the sheet (adding
subtotal after the filter is in place, enter a sum and let
it convert into a subtotal) trying different things. I
have been able (in the past)to create a subtotal that
works perfectly with any filter combination. But I forgot
how I got there. .. any help ?
 
First of all, put the formula with the subtotal outside of the filter range,
i.e. if you have a header
in A1 and the filter range is A2:A500, put the formula in Row 1 somewhere.
That way it will
not disappear. Also apply the formula when you are not filtering anything

=SUBTOTAL(9,A2:A500)

then filter
 
Back
Top