GROUPBY

GROUPBY helps you perform data calculation and analysis in AirSheet worksheets. It provides the tools you need to enter and use the function accurately, making your work more efficient and helping you accomplish tasks with ease. With GROUPBY, you can input the formula in a cell or formula bar, view automatic syntax prompts with parameter requirements and examples, use flexible parameters for different calculation scenarios, support cross-worksheet references and nested calculations, and get results that update automatically when source data changes. Whether you're checking formula syntax, correcting parameter or reference issues, or manually triggering recalculation when results seem incorrect, GROUPBY 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