How to Use Subtotal in Excel (And Google Sheets) What makes SUBTOTAL such an obvious choice is its flexibility—you get way more options without any extra complexity compared to SUM.