Excel Magic Trick #13: SUM or COUNT only certain items! SUMIF COUNTIF functions

Share this & earn $10
ExcelIsFun
Published at : 15 Dec 2020
667551 views
2043
288

Download Excel Files: Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MikeGelGirvinYouTubeExcelMagicTrick11-22.xls Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MikeGelGirvinYouTubeExcelMagicTrick11-22Finished.xls This is an OLD video. Here is updated video, much better: https://www.youtube.com/watch?v=6c9fIZys7ng
See how to use the SUMIF and COUNTIF functions to add and count given a certain condition. With this trick you can add only the sales for the salesperson Tina -- or count them! Also, see the super fast keyboard shortcut for naming multiple ranges.

Count words text based on a Condition. Count words text based on criteria. SUM Values based on a Condition. SUM Values based on criteria.
MicrosoftExcelspreadsheets

Kymera - The Utterly Insane Chevy 4X4 | RIDICULOUS RIDES

Kymera - The Utterly Insane Chevy 4X4 | RIDICULOUS RIDES

COMMONLY USED FILIPINO Phrases and Sentences! #5 (English-Tagalog)

COMMONLY USED FILIPINO Phrases and Sentences! #5 (English-Tagalog)

HCG FAQ-Will you guarantee that the HCG Lean Extreme Diet and Plan will work for me?

HCG FAQ-Will you guarantee that the HCG Lean Extreme Diet and Plan will work for me?

How the Left Sees the World: Power, Race, and Class

How the Left Sees the World: Power, Race, and Class

Puzzling (Ocarina of Time Romhack) Playthrough

Puzzling (Ocarina of Time Romhack) Playthrough

Term Insurance plan - detail explanation

Term Insurance plan - detail explanation

SOP FAMILY - INDUSTREET THEME SONG (OFFICIAL VIDEO & LYRICS)

SOP FAMILY - INDUSTREET THEME SONG (OFFICIAL VIDEO & LYRICS)

Употребление to be going to в сравнении с Future Simple и Present Continuous.

Употребление to be going to в сравнении с Future Simple и Present Continuous.

Stay Up Here - Sebastian Forslund

Stay Up Here - Sebastian Forslund

How To Check Apple Watch Battery Health!

How To Check Apple Watch Battery Health!

Everything You Need To Know About VILLAGERS In Minecraft!

Everything You Need To Know About VILLAGERS In Minecraft!

TWIGLET PARK RIP!

TWIGLET PARK RIP!

The Hollies - He Ain't Heavy, He's My Brother

The Hollies - He Ain't Heavy, He's My Brother

Video SparkNotes: Mary Shelley's Frankenstein summary

Video SparkNotes: Mary Shelley's Frankenstein summary

Peru Library audit "you need permission to film individuals"😆

Peru Library audit "you need permission to film individuals"😆

Michel Gondry - Around the world - Daft Punk (Partizan Classics 1997)

Michel Gondry - Around the world - Daft Punk (Partizan Classics 1997)

Mukbanger moments I WISH I COULD UNSEE

Mukbanger moments I WISH I COULD UNSEE

За спичками (комедия, реж. Леонид Гайдай, Ристо Орко, 1980 г.)

За спичками (комедия, реж. Леонид Гайдай, Ристо Орко, 1980 г.)

How to Break Down a Chicken Like a Pro

How to Break Down a Chicken Like a Pro

Taekook being obvious and bold showed their relationship

Taekook being obvious and bold showed their relationship

Kool & the Gang - Celebration

Kool & the Gang - Celebration

Part 1/3 - Why did you convert to Islam?

Part 1/3 - Why did you convert to Islam?

Dukes Of The Orient - "The Monitors" - Official Music Video

Dukes Of The Orient - "The Monitors" - Official Music Video

Myanmar coup, detention of Aung San Suu Kyi and the strategic implications for the region & India

Myanmar coup, detention of Aung San Suu Kyi and the strategic implications for the region & India

How I Knew I Was Pregnant BEFORE I Got My BFP! no morning sickness, sore boobs or craving symptoms!!

How I Knew I Was Pregnant BEFORE I Got My BFP! no morning sickness, sore boobs or craving symptoms!!

Digging out /stoning up and laying concrete driveway.

Digging out /stoning up and laying concrete driveway.

ONLY IN JAPAN - World's Fastest Things

ONLY IN JAPAN - World's Fastest Things

xQc Reacts to Uncommon Clips 1 (Streamers Out of Context)

xQc Reacts to Uncommon Clips 1 (Streamers Out of Context)

Dvila Ft. Almighty - Indispensable

Dvila Ft. Almighty - Indispensable

High Level Event II -- Leadership for the Africa we Want - Kigali, Wednesday 22 May 2015

High Level Event II -- Leadership for the Africa we Want - Kigali, Wednesday 22 May 2015

HOW WE BECAME THE *RICHEST* ON THE ENTIRE SERVER! | Minecraft Skyblock | OPLegends #2

HOW WE BECAME THE *RICHEST* ON THE ENTIRE SERVER! | Minecraft Skyblock | OPLegends #2

Himalayan Salt and Scents Salt Glue Comparison Testing

Himalayan Salt and Scents Salt Glue Comparison Testing

Letter of Intent | How to select Turkish University | Turkey Burslari Scholarship | Part 2

Letter of Intent | How to select Turkish University | Turkey Burslari Scholarship | Part 2

ASU - DEPENDENT DE TINE

ASU - DEPENDENT DE TINE

Creating a Focal Point

Creating a Focal Point

Escalating protests force Omar Jimenez's crew to flee to safety

Escalating protests force Omar Jimenez's crew to flee to safety

Assassin's Creed: Valhalla - Soma's Death Scene

Assassin's Creed: Valhalla - Soma's Death Scene

Peter Gabriel - Growing Up

Peter Gabriel - Growing Up

Trip to Georgia stopover at Beautiful Warsaw

Trip to Georgia stopover at Beautiful Warsaw

An Education Trailer

An Education Trailer

Lady Gaga - Applause (Soufjan) | The Voice Kids 2014 | Blind Audition | SAT.1

Lady Gaga - Applause (Soufjan) | The Voice Kids 2014 | Blind Audition | SAT.1

Watchin' Baggage #27 | The Worst Batch of Guys

Watchin' Baggage #27 | The Worst Batch of Guys

Learn everything about probability in 3 mins!

Learn everything about probability in 3 mins!

50 Cent - 21 Questions (Official Music Video) ft. Nate Dogg

50 Cent - 21 Questions (Official Music Video) ft. Nate Dogg

ateez being shy

ateez being shy

SANTA CLOWN'S *WEIRDEST* LOBBY EVER! | DBD (Cursed Legacy Update) Oni / Clown

SANTA CLOWN'S *WEIRDEST* LOBBY EVER! | DBD (Cursed Legacy Update) Oni / Clown

SUV Sleeping platform By Freeway Camper Kit!

SUV Sleeping platform By Freeway Camper Kit!

HOW TO OPERATE - A Front End Loader! HD 6:51 Play time!

HOW TO OPERATE - A Front End Loader! HD 6:51 Play time!

Bach Study Music Playlist 🎻 Instrumental Classical Music Mix for Studying, Concentration, Relaxation

Bach Study Music Playlist 🎻 Instrumental Classical Music Mix for Studying, Concentration, Relaxation