Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

Problems with Totals using automatic filter.

Posted by Maarten on January 20, 2002 7:20 AM

I've made a automatical filter bescause the most answers in the worksheet can do well with Yes or NO.

First I made a filter, below the table I've made a total row using the COUNTIF statement.

The problem is when I'm using the table on "all categories" Excelworks perfectly, but when I want him to show some specific information, he hides my total row and that row is just the information I need to use for the next step!

Please help. Thanks

Re: Problems with Totals using automatic filter.

Posted by bj on January 21, 2002 11:53 AM

The problem is that there are no blank rows between the total row and the last row of data in the filter. Insert two rows where the total is or highlight the row(s) separating your data and the totals and go to EDIT/CLEAR ->ALL

doing either of these should take care of it for you.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.