COLUMNS

COLUMNS helps you calculate and analyze data by returning results based on the columns in a referenced range. It provides the tools you need to enter formulas efficiently, making your work more efficient and helping you accomplish tasks with ease. With COLUMNS, you can type the function directly in a cell or formula bar, view automatic syntax guidance with parameter requirements and examples, use flexible parameters for different calculation scenarios, reference ranges across worksheets, and include the function in nested calculations. Results update automatically when source data changes, and you can manually recalculate if needed. Whether you're checking formula syntax, correcting parameter errors, or troubleshooting incorrect results caused by text-formatted numbers or circular references, COLUMNS 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