AREAS

AREAS helps you perform data calculation and analysis in AirSheet worksheets. It provides the tools you need to enter the function quickly, use flexible parameters for different calculation scenarios, and work more efficiently with automatic recalculation when source data changes. With AREAS, you can type the formula in a cell or formula bar, view syntax prompts with parameter requirements and examples, use cross-worksheet references, and include nested calculations. If errors appear, you can check formula syntax, parameter type and count, bracket matching, separators, text-formatted numbers, or circular references, and manually trigger recalculation when needed. Whether you're building formulas for routine analysis or troubleshooting incorrect results, AREAS helps you complete calculations efficiently. Choose the documentation below that best matches your needs to learn more.

1:53