The first argument ( function_num ) determines whether the formula ignores manually hidden rows. Includes manually hidden rows Ignore Hidden Ignores manually hidden rows
Excel has a built-in feature to automatically insert subtotals at every change in a category. subtotal in excel
Both sets (9 and 109) ignore rows hidden by a filter. Method 1: Using the SUBTOTAL Function (Formula) The first argument ( function_num ) determines whether