FILTER

FILTER helps you perform data calculation and analysis in AirSheet worksheets. It provides the tools you need to enter and use the FILTER function efficiently, making your work more efficient and helping you accomplish tasks with ease. With FILTER, you can start formulas with =, enter FILTER( to view syntax prompts with parameter requirements and examples, supply the correct arguments, and confirm the formula to return results in cells. It also supports flexible parameters, cross-worksheet references, nested calculations, and automatic recalculation when source data changes. Whether you're writing formulas, checking syntax, correcting parameter or punctuation errors, reviewing examples, or troubleshooting incorrect results caused by text-formatted numbers or circular references, FILTER 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