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