Google Sheets - Use ARRAYFORMULA Instead of Repeating Functions

Share this & earn $10
Prolific Oaktree
Published at : 13 Feb 2021
721 views
20
0

The ARRAYFORMULA allows you to replace a series of formulas with just one. The functions 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:
🎓Master the Fundamentals of Google Sheets - http://bit.ly/PO-Basics
🌳 Next Video - Pivot Tables in Sheets vs. Excel - https://youtu.be/NHdU39niU7A
🌳 Related Playlist - Google Apps | Full Tutorials - https://bit.ly/google-tutorials

#googlesheets #ARRAY #ARRAYFORMULA
google sheetsarrayarrayformula

Daniele De Martino - A 15 Anne

Daniele De Martino - A 15 Anne

A look inside Wuhan quarantine ward for seriously ill

A look inside Wuhan quarantine ward for seriously ill

Coming Market Crash or Rocket? w/ $200 Million Dollar Investor [Ali Moiz]

Coming Market Crash or Rocket? w/ $200 Million Dollar Investor [Ali Moiz]

You Can Own a 4 Bedroom Duplex Anywhere in the World by December 2021

You Can Own a 4 Bedroom Duplex Anywhere in the World by December 2021

ASKING ALEXANDRIA - Antisocialist (Official Music Video)

ASKING ALEXANDRIA - Antisocialist (Official Music Video)

Calculus 1 - Introduction to Limits

Calculus 1 - Introduction to Limits

Judge has harsh words for teen suing parents

Judge has harsh words for teen suing parents

What Are The 5 Best Tools For Performance Management?

What Are The 5 Best Tools For Performance Management?

James Arthur - Recovery (Lyrics On Screen)

James Arthur - Recovery (Lyrics On Screen)

Beauty within using stamp and layered stencil

Beauty within using stamp and layered stencil

Habits that make snowboarding way harder| Beginner Guide

Habits that make snowboarding way harder| Beginner Guide

Silicone Mold Making - Three Different Ways

Silicone Mold Making - Three Different Ways

Home Tiffin Center Anantapur - Wide variety of Dosas

Home Tiffin Center Anantapur - Wide variety of Dosas

How to Build Unique Links to Skyrocket SEO Rankings (2018) | Backlink Strategies to Rank on Google

How to Build Unique Links to Skyrocket SEO Rankings (2018) | Backlink Strategies to Rank on Google

DIY Paper Flower BOUQUET/ Birthday gift ideas/Flower Bouquet making at Homemade Easy Craft (Cute)

DIY Paper Flower BOUQUET/ Birthday gift ideas/Flower Bouquet making at Homemade Easy Craft (Cute)

Fastest Sprint Speeds in Football 2021 ᴴᴰ

Fastest Sprint Speeds in Football 2021 ᴴᴰ

12 Men's Summer Style Essentials

12 Men's Summer Style Essentials

Playing CURSED Minecraft With REALISTIC PHYSICS..

Playing CURSED Minecraft With REALISTIC PHYSICS..

2020 Curiously Cinnamon Crave those Crazy Squares Advert

2020 Curiously Cinnamon Crave those Crazy Squares Advert

Biden Reveals Covid Plan One Year After Virus Was Found In U.S. | The 11th Hour | MSNBC

Biden Reveals Covid Plan One Year After Virus Was Found In U.S. | The 11th Hour | MSNBC

Brenda Mage, ikinuwento na dati siyang nag-audition sa I Can See YourVoice | I Can See Your Voice PH

Brenda Mage, ikinuwento na dati siyang nag-audition sa I Can See YourVoice | I Can See Your Voice PH

Best Hangover Cures You Haven't Tried

Best Hangover Cures You Haven't Tried

Oaxaca

Oaxaca

Anticipate - The Art of Leading by Looking Ahead

Anticipate - The Art of Leading by Looking Ahead

Firing Line with William F. Buckley Jr.: Shockley's Thesis

Firing Line with William F. Buckley Jr.: Shockley's Thesis

THE GODFATHER CODA: THE DEATH OF MICHAEL CORLEONE | Francis Ford Coppola Featurette

THE GODFATHER CODA: THE DEATH OF MICHAEL CORLEONE | Francis Ford Coppola Featurette

Tiësto - Traffic

Tiësto - Traffic

Let's Play Alien: Isolation Part 15 - Find An Alternate Communications Channel

Let's Play Alien: Isolation Part 15 - Find An Alternate Communications Channel

CHEMISTRY 101: Significant figures in calculations

CHEMISTRY 101: Significant figures in calculations

Learn English word what is  Initially , how to use of initially  (Word of the day  Part 5th)

Learn English word what is Initially , how to use of initially (Word of the day Part 5th)

Wood Turning A Segmented Decanter or Vase With A Twist

Wood Turning A Segmented Decanter or Vase With A Twist

[ENG SUB] Dear Mayang Street 01 (Seven Tan, Timmy Xu, Niu Junfeng)

[ENG SUB] Dear Mayang Street 01 (Seven Tan, Timmy Xu, Niu Junfeng)

【神魔討綺伝】 AN ORDEAL FROM GOD 【MIDI】

【神魔討綺伝】 AN ORDEAL FROM GOD 【MIDI】

professional of throw a cast net catching many many fishes for food daily life.

professional of throw a cast net catching many many fishes for food daily life.

Informal words to use instead of 'moreover' and 'furthermore'

Informal words to use instead of 'moreover' and 'furthermore'

WACC, Cost of Equity, and Cost of Debt in a DCF

WACC, Cost of Equity, and Cost of Debt in a DCF

xQc Reacts to memes that defy the laws of physics

xQc Reacts to memes that defy the laws of physics

MRVZ - No One (Official Video)

MRVZ - No One (Official Video)

Гордон: Если бы над украинцами издевались так, как над белорусами, в силовиков бы уже стреляли

Гордон: Если бы над украинцами издевались так, как над белорусами, в силовиков бы уже стреляли

Jordan Peterson: The Mind of Highly (Dis-)Agreeable People

Jordan Peterson: The Mind of Highly (Dis-)Agreeable People

BTS: Tiny Desk (Home) Concert

BTS: Tiny Desk (Home) Concert

Cake - Long Time -- Lyrics

Cake - Long Time -- Lyrics

Masking a Car

Masking a Car

NEEDTOBREATHE - "Multiplied" [Official Audio]

NEEDTOBREATHE - "Multiplied" [Official Audio]

Zach Galifianakis Recalls the Louis C.K. Phone Call that Created Baskets

Zach Galifianakis Recalls the Louis C.K. Phone Call that Created Baskets

Silenced 12 Gauge Icy Mallard Hole Duck Hunt! 7 Man Limit

Silenced 12 Gauge Icy Mallard Hole Duck Hunt! 7 Man Limit

How to take your seat of authority (Ephesians 1-2) - Billye Brim

How to take your seat of authority (Ephesians 1-2) - Billye Brim

Satisfying Slime ASMR | Relaxing Slime Videos # 1111

Satisfying Slime ASMR | Relaxing Slime Videos # 1111

Man Finds $$$110,000.00 Cash ! Angel Beach Treasure Hunt ! Lost Drug Money !شاب عثر على كنز

Man Finds $$$110,000.00 Cash ! Angel Beach Treasure Hunt ! Lost Drug Money !شاب عثر على كنز