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 ...
There are two quotes remaining on the screen: 18,000 yen and 12,000 yen. Even though it should be 30,000 yen on a calculator, ...
Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don’t worry–a simple conditional function can handle the request. Subtotals are common in a lot of Excel ...
We all start with SUM. It’s simple and reliable — until your data gets messy. Once you begin filtering or hiding rows, SUM no longer reflects what you see. That’s when SUBTOTAL helps. It can ignore ...
Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data. Editor’s Note: This article was originally published in Sept. 2012 and the ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results