MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

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.