SUBTOTAL

SUBTOTAL helps you calculate and analyze data in AirSheet / Worksheet. It provides the tools you need to perform data calculations with flexible parameters, making your work more efficient and helping you accomplish tasks with ease. With SUBTOTAL, you can enter the function directly in a cell or formula bar, view automatic syntax prompts with parameter requirements and examples, use it for different calculation scenarios, reference data across worksheets, and support nested calculations with results that update automatically when data changes. Whether you're writing formulas, checking syntax, correcting parameter or reference errors, or manually recalculating when needed, SUBTOTAL helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.

1:53