arrayformula

The ARRAYFORMULA function is a powerful tool in Google Sheets that allows you to spread formula outputs across multiple rows and columns. It can extend 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 … Read more