Unlike SUM, which ignores filters, SUBTOTAL dynamically adjusts to display only visible data. It offers 11 built-in functions, with additional options (101-111) that account for hidden rows. When ...
After filtering a table, you may find that even though only a few rows are visible on the screen, the total remains the same as the original figure. Before you copy the visible rows and re-add them, d ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results