Using SUMIFS and COUNTIFS in Excel | Excel Practice Case #21
Using SUMIFS and COUNTIFS in Excel | Excel Practice Case #21
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ Subtitles Available in 12 languages
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
SUMIF, SUMIFS, COUNTIF, and COUNTIFS are extremely useful and powerful for data analysis. If there was an Excel Function Hall of Fame, this family of functions ought to be included. In this Excel Practice case, I'll demonstrate the use of the SUMIFS and COUNTIFS function focusing mainly on all the different criteria types.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
╔═╦╗╔╦╗╔═╦═╦╦╦╦╗╔═╗
║╚╣║║║╚╣╚╣╔╣╔╣║╚╣═╣
╠╗║╚╝║║╠╗║╚╣║║║║║═╣
╚═╩══╩═╩═╩═╩╝╚╩═╩═╝
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🙋🏼♂️ PLEASE SUBSCRIBE
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✅ SUBSCRIBE HERE 👉 https://bit.ly/3cQUVZZ
🆓 DOWNLOAD the Exercise file and solution for this video here 👉
SUPPORT THE CHANNEL
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
👉Teespring Merch&Books 👉 https://bit.ly/3S1fa7n
Social Media / Contact us
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
🤳Dexcelo on TikTok 👉 https://bit.ly/3JgslNU
📥 Business Inquiries 👉 dexcelo03@gmail.com
📊 In this course you will learn how to:
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
- Use the SUMIFS Function to find the total order per country
- Use the COUNTIFS Function to count the number of orders per country
- Use the absolute and relative cell references when needed
- Use the CTRL + Enter shortcut to paste the formulas
- Insert a Pie Chart to present the total order amounts per country
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
✏️ Course developed by Dexcelo.
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⭐️ APPROXIMATE CONTENT TIMESTAMPS ⭐️
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
0:00:00 - 0:03:28 Intro & Objectives
0:03:28 - 0:11:19 Using SUMIFS
0:11:19 - 0:15:56 Using COUNTIFS
0:15:56 - 0:17:06 Inserting a Pie Chart
0:17:06 - 0:18:56 Objectives Summary
🔗 Useful Links
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
⚈ Microsoft Excel Help Center https://bit.ly/3Q99vu8
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Thank you for your support 🙏🙏🙏 !!!
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Tags
#excel #اكسل #learnexcel #excelshortcuts #exceltips #shortcuts #microsoftexcel #microsoft #exceltutorial
-
2:17:12
vivafrei
15 hours agoEp. 217: Biden Debate Debacle; SCOTUS Jan. 6; SCOTUS Chevron; Trump AND MORE!
136K516 -
2:00:31
RealAmericasVoice
4 hours agoNEXT MAN UP: STEVE BANNON, CHARLIE KIRK, AND JACK POSOBIEC
38.6K32 -
1:16:29
The Late Kick with Josh Pate
7 hours agoLate Kick Live Ep 526: FSU’s ACC Exit | SEC vs Texas & OU | Lanning Is Kirby | EASports CFB25
29.1K4 -
4:23:09
Due Dissidence
11 hours agoLiberals' Post-Debate MELTDOWN CONTINUES, Russ Interviews 'Pod Save America' Fans in NYC
43.6K53 -
27:33
Texas Strong
2 days agoThe Texas Revolution - Episode 01 - 06-28-24
28.3K3 -
LIVE
Vigilant News Network
9 hours agoMedia Blackout: 10 News Stories They Chose Not to Tell You - Episode 29
1,264 watching -
43:19
Stephen Gardner
8 hours ago🔴BREAKING: Biden is a TRAIN WRECK! Obama WANTS him GONE!!
61.1K165 -
7:32:40
FusedAegisTV
12 hours agoDid I Crash Servers?! Wonderous Tails XP Farming | Final Fantasy XIV 7.0 Early Access Day 3
59.3K2 -
1:43:48
Bright Insight
1 day agoWhat You Must Know about Graham Hancock/Flint Dibble Debate (w/ @DeDunking)
142K91 -
47:41
Digital Social Hour
15 hours agoLiving Longer and Healthier with Gary Brecka | Digital Social Hour
67.5K16