Introduction
Array formulas let you do calculations on multiple values at once. They help you get results from many cells with one formula, saving time and effort.
When you want to add numbers from two columns cell by cell without writing many formulas
When you need to count how many cells meet multiple conditions at the same time
When you want to multiply two lists of numbers and get all results in one step
When you want to find the maximum or minimum from a set of calculated values
When you want to perform calculations that return more than one result in adjacent cells