![]() You have to re-enter the formula, start a full recalculation (Ctrl+Alt+F9) or save-reopen the file to have the correct result after deactivating the filter:īased on our test results, we can say that subtotal first checks if the filter is active on the sheet or not. The subtotal in cell F14 gives incorrect result if you hide rows when the filter is active on the worksheet (remember, it should include the hidden values):ĭeactivating the filter will NOT change the result immediately: The second list from B15 to B20 is not part of the filter, and it contains 6 rows: both of the subtotalss give 6 because no row is hidden. ![]() On the below screenshot you can see a correct result while the small list from B5 to C10 is filtered. Seems it is not the case - subtotal is not prepared to be able to separate the two kind of hidden rows. So if subtotal is expected to work as it is described in the Help, it should somehow make difference between the rows hidden by the filter and hidden by the Hide Rows commands. If a row is filtered out from a list, it becomes hidden, in VBA the. The problem is that technically filters work with hiding rows. Important to know that both of the sets ignore any rows that are not included in the result of a filter.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |