SUMPRODUCT

SUMPRODUCT helps you perform data calculation and analysis in AirSheet worksheets. It provides the tools you need to multiply and sum arrays with flexible parameters, making your work more efficient and helping you accomplish tasks with ease. With SUMPRODUCT, you can enter the formula directly in a cell or formula bar, view automatic syntax prompts with parameter requirements and examples, use cross-worksheet references, and build nested calculations with results that update automatically when data changes. Whether you're checking formula syntax, correcting parameter or delimiter errors, reviewing examples while entering a formula, or manually recalculating when results seem incorrect, SUMPRODUCT helps you stay productive and complete tasks efficiently. Choose the documentation below that best matches your needs to learn more.

1:53