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:

#googlesheets #ARRAY #ARRAYFORMULA

[decidebright]

Love your style of video creation. Simple, to the point. No fat to it.

Thanks!

[southhack]

How can I make one column the date format and an other column time format using arrayformula?

[CB-nvbs]

This is completely off-topic but the birds chirping in the background is so nice and relaxing. Makes me jealous as a city girl that only hears cars, haha.

[lion_of_judahgaming]

How can I use an arrayformula like this on a date to show how many days its been since that date? I've seen it done but when I copy the process into my own work it comes out to a huge negitive number instead of a positive going up, and if I convert that number into a date it shows 1/9/1779 instead of the current date compared to the date already imput.

[stoleethatsme]

Thank you so much for making this video. I really appreciate you taking the time to do so! New subscriber here.

[CasBox]

awesome and simple explanation, thanks a lot!

[SaretGnasoh]

How to use arrayformula for sumifs before date.
I can arrayformula sumif for sumifs, but can not for date range

[Karunakar]

Hi
How To Set Color With Formula By Percentage In Google Sheet

[euroindiaseafood]

Hello Sir, please can you let me know the formula Automatically Insert a Blank Row below Each Group data in Google Sheets

[Dan]

Is there any reason to just copy down the formula instead of using ARRAYFORMULA?

[nadine-]

this was so easy to follow thank you so much!!

[ShreeMulay]

Can we use the ARRAYFORMULA with chained, IF statements?

[minimaggot]

You should wrap it in an IF(NOT(ISBLANK.

[starzee]

Hi Can you make a video on how to track timely views on YouTube like every hour (not real time views)

[Ninjatravels]

Everyone skips the part to delete the zero.. 🤦‍♂️