Premium Only Content
![Using SUMIFS and COUNTIFS in Excel | Excel Practice Case #21](https://1a-1791.com/video/s8/1/J/A/4/I/JA4Ig.qR4e-small-Using-SUMIFS-and-COUNTIFS-i.jpg)
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
-
57:12
Candace Show Podcast
1 hour agoJudge Slaps Down Blake Lively. Colleen Hoover Returns. | Candace Ep 146
46.8K15 -
LIVE
Melonie Mac
2 hours agoLet's Watch Playstation State of Play
553 watching -
LIVE
Revenge of the Cis
3 hours agoLocals Episode 196: Aloha
433 watching -
1:05:34
In The Litter Box w/ Jewels & Catturd
22 hours agoReturn to Sender | In the Litter Box w/ Jewels & Catturd – Ep. 740 – 2/12/2025
36.1K26 -
1:32:17
The Quartering
4 hours agoDOGE Storms the Department of Education, Trump FIRES USAID head, and Teacher freed from Russia
95.4K43 -
59:57
The White House
4 hours agoPress Secretary Karoline Leavitt Briefs Members of the Media, Feb. 12, 2025
188K227 -
LIVE
John Crump Live
4 hours agoBreaking Down The J6 Pardons With The J6 Pardon Project
166 watching -
1:09:47
Tucker Carlson
4 hours agoKen Paxton: How Soros Protects Drug Cartels, Being Blacklisted by Fox News, and the Laken Riley Act
157K118 -
1:23:49
Film Threat
8 hours agoCAPTAIN AMERICA: BRAVE NEW WORLD REVIEW (NON-SPOILER) | Hollywood on the Rocks
16.1K4 -
LIVE
The Nunn Report - w/ Dan Nunn
2 hours ago[Ep 607] Constitutional Crisis! There Is No Proof! AAARRRGG! – Leftist Lunacy & Why It Will Fail
336 watching