Google Sheets: Arrayformulas to write one formula and populate a whole column of values
Arrayformulas populate a whole column of values, for example, with one formula. See how to use arrayformula with countif and averageif formulas.
Note: Not all formulas can be used with arrayformula(). In particular, sum, average, and averageif formulas cannot, so in those cases, use + - / *
Copy Demo Sheet: https://doittraining.page.link/easier...
Slides: https://docs.google.com/presentation/...