AGGREGATE

AGGREGATE helps you perform data calculation and analysis in AirSheet. It provides the tools you need to enter the function quickly, use flexible parameters for different calculation scenarios, and work more efficiently as results update automatically when source data changes. With AGGREGATE, you can write formulas by starting with =, enter AGGREGATE( to view syntax guidance with parameter requirements and examples, use cross-worksheet references, and build nested calculations. If a result is incorrect, you can check formula syntax, parameter count and types, unmatched parentheses, missing separators, text-formatted numbers, or circular references, and manually recalculate when needed. Whether you're creating formulas for routine analysis or troubleshooting calculation errors, AGGREGATE helps you stay productive and complete tasks efficiently across different work environments. Choose the documentation below that best matches your needs to learn more.

1:53