PIVOTBY

PIVOTBY helps you perform data calculation and analysis in AirSheet. It provides the tools you need to enter the function quickly, work with flexible parameters, and handle different calculation scenarios more efficiently. With PIVOTBY, you can write formulas by starting with =, view automatic syntax prompts with parameter requirements and examples, use cross-worksheet references, create nested calculations, and get results that update automatically when source data changes. Whether you're checking formula syntax, correcting parameter count or type issues, reviewing unmatched parentheses or missing separators, or troubleshooting incorrect results caused by text-formatted numbers or circular references, PIVOTBY helps you complete calculations accurately and efficiently. Choose the documentation below that best matches your needs to learn more.

1:53