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
-
1:34:26
Kim Iversen
11 hours agoBioLab On Fire, People Are Underwater and Is Israel Our Greatest Ally or Greatest Threat?
92.3K268 -
8:49
Colion Noir
9 hours agoIs Carbon Fiber The Future of Carry Guns | Kimber R7 Carbon Compact
55.9K28 -
1:14:31
Donald Trump Jr.
17 hours agoOn Every Issue, the Left is Lying, Interviews with Ned Ryun & Dinesh D’Souza | TRIGGERED Ep.178
144K169 -
3:15:49
The Breanna Morello Show
17 hours agoMike Benz in Studio: Hillary Clinton & John Kerry Declare War on First Amendment | The Breanna Morello Show
86.7K41 -
1:54:42
Kimberly Guilfoyle
14 hours agoSave America: President Trump in Erie, PA- Replay September 29
115K51 -
59:12
Flyover Conservatives
1 day agoUN Power Grab… Are They Using Google to Control Dissent and Push Propaganda? - Alex Newman; Economic Update - Dr. Kirk Elliott | FOC Show
77.4K8 -
1:13:55
Abigail Joy
9 hours agoYou're Not Bullish Enough! - Human 1.0 w/ Abigail Joy - September 30 2024 - LIVE STREAM
60.9K4 -
14:35
China Uncensored
9 hours agoI Wasn’t Expecting THIS Would Turn China Against Xi Jinping
67.6K19 -
55:21
LFA TV
23 hours agoNetanyahu Understands War | Trumpet Daily 9.30.24 9PM EST
59K21 -
1:13:17
We Like Shooting
22 hours agoDouble Tap 377 (Gun Podcast)
45.7K