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
Watch video Google Sheets - Use ARRAYFORMULA Instead of Repeating Functions online without registration, duration hours minute second in high quality. This video was added by user Prolific Oaktree 16 January 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 70,12 once and liked it 48 people.