FREQUENCY

FREQUENCY helps you perform data calculation and analysis in AirSheet worksheets. It provides the tools you need to enter the function quickly, review syntax guidance, and calculate results efficiently, making your work more efficient and helping you accomplish tasks with ease. With FREQUENCY, you can start a formula with =, enter FREQUENCY( to view parameter requirements and examples, supply the correct arguments, and return results in a cell. It also supports flexible parameters, cross-worksheet references, nested calculations, and automatic recalculation when source data changes. Whether you're correcting syntax errors, checking parameter types and counts, reviewing examples from the built-in syntax prompt, or troubleshooting incorrect results caused by text-formatted numbers or circular references, FREQUENCY helps you stay productive. Choose the documentation below that best matches your needs to learn more.

1:53