ROWS

ROWS helps you calculate and analyze data by returning results based on the number of rows in a reference or range. 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 ROWS, you can type a formula starting with =, enter ROWS( to view syntax guidance with parameter requirements and examples, use cross-worksheet references, and include nested calculations. Whether you're checking formula syntax, correcting parameter or bracket errors, reviewing function examples, or troubleshooting incorrect results caused by text-formatted numbers or circular references, ROWS 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