Google Sheets - Use ARRAYFORMULA Instead of Repeating Functions
The ARRAYFORMULA allows you to replace a series of formulas with just one. The function works with ranges instead of single cells.
🕒 Timestamps:
0:00 The Simple Way (without ARRAYFORMULA)
0:44 SUM a range with ARRAYFORMULA
1:24 Make it a long range
2:09 Tighten up the range
2:22 Nested ARRAYFORMULA to get an AVERAGE
3:35 UNIQUE function
Learn more from Prolific Oaktree:
🌳 Next Video - Pivot Tables in Sheets vs. Excel - • Pivot Tables | Google Sheets vs MS Ex...
🌳 Related Playlist - Google Apps | Full Tutorials - https://bit.ly/google-tutorials
#googlesheets #ARRAY #ARRAYFORMULA