SUBTOTAL(9,range) Does NOT work in AutoFilter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have used this function before and had no problem.
I do not understand why it is not working for me now.
I have approx. 1600 rows of data and I have three columns with the subtotal
function entered in the row under the last row of data.

When I filter on a specific the data value in one column that I want to get
a subtotal for, the row wihere the subtotal function is entered does not
display.

Can someone help with this problem please.
 
Put the subtotal formula in the top row and see if that works

--
Regards,

Peo Sjoblom

(No private emails please)
 
Thank you Peo. Yes that does work, but I really wanted to have all the
subtotals at the bottom. But if there is no other choice, this will have to
do.

Thank you.
 
If you have totals in the row below the subtotals, the subtotals row
will be hidden when you apply the AutoFilter.

Maybe you could leave a blank row between the table and the subtotals.
Then, remove the AutoFilter, and reapply it.
 
Debra; thank you ever so much.
Yes, I did have other totals below the subtotal row.
Your suggestion to add an empty row below the subtotal row was brilliant and
solved my problem.

Thank you, Dane...
 
You're welcome. Thanks for letting me know that it solved the problem.
 
You must log in or register to reply here.

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

Average of Subtotals in Pivot Table 0
Additonal info into newly created Subtotal row 1
Nesting SUBTOTAL with SUMPRODUCT? 0
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
Subtotal of Abs of a range? 3
subtotal function won't work 1
SubTotal function to return number of rows returns only zero 4
subtotal, match? 10

Back
Top