COLUMNS

COLUMNS helps you calculate and analyze data in AirSheet by returning results through a commonly used function formula. It provides the tools you need to enter formulas quickly, use flexible parameters for different calculation scenarios, and work more efficiently as data changes automatically trigger recalculation. With COLUMNS, you can start a formula with =, enter COLUMNS(, review automatic syntax prompts with parameter requirements and examples, and confirm the formula to display the result in a cell. It also supports cross-sheet references and nested calculations, giving you flexibility in how you build formulas. Whether you're troubleshooting syntax errors, checking parameter types and counts, correcting reference issues, or manually recalculating when needed, COLUMNS 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