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
-
1:05:35
Man in America
12 hours agoFort Knox & Trump’s Secret Gold Move—The Financial Reset NO ONE Is Ready For?
78.4K41 -
2:21:20
Robert Gouveia
9 hours agoTrump Goes to SCOTUS! Judge CAVES on DOGE? Fani Willis Not Happy!
101K30 -
20:41
Stephen Gardner
9 hours ago🔥You Won't BELIEVE What JUST Happened To Don Trump Jr.!!
105K142 -
58:00
The StoneZONE with Roger Stone
7 hours agoEuropean Leaders Resist Trump Peace Overtures To Their Own Demise | The StoneZONE w/ Roger Stone
73.3K12 -
9:29
AlaskanBallistics
9 hours ago $7.25 earnedWyoming Suppressors and Rifles at Shot Show 2025
82.6K4 -
1:06:40
Donald Trump Jr.
13 hours agoThe Left is Taking one L After Another, Live with Michael Knowles | Triggered Ep. 217
175K113 -
47:17
Kimberly Guilfoyle
13 hours agoWoke Gets DOGE’d, Live with AJ Rice & Jarrett Stepman | Ep. 197
129K43 -
20:11
Candace Show Podcast
11 hours agoBecoming Brigitte: Candace Owens x Xavier Poussard | Ep 6
193K330 -
8:25:38
Dr Disrespect
16 hours ago🔴LIVE - DR DISRESPECT - ELDEN RING DLC - REVENGE
194K22 -
54:22
LFA TV
1 day agoThe End of the Trans-Atlantic Alliance | TRUMPET DAILY 2.17.25 7PM
50.2K7