ARRAYFORMULA Function – Google Sheets

The ARRAYFORMULA function spreads its output across multiple rows and columns. You can use this function to repeat non-array functions such as SUM, PRODUCT, or AVERAGE. As with other functions that generate arrays, such as FILTER and QUERY, the output needs space to expand below and right. Keep this in mind so you do not … Read more