Excel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria)
February 10, 2017 Excel Intermediate Functions & Features (For ALL Excel Versions)
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
Quickly learn how SUMIFS & COUNTIFS formulas work - and why they are better than SUMIF & COUNTIF formulas.
★ Get the full course: https://www.xelplus.com/courses
The inclusion of the "IFS" formulas since Excel 2007 was a major gain for Excel users. Why? Because they allow you to easily add exceptions to your sum, average and count calculations. Don’t make your life more difficult by trying to use excel filters to get your sum. Use the SUMIFS formula instead. You can SUM based on multiple criteria. You can also use SUMIFS to sum if numbers are greater than a certain value.
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
Timestamps:
00:00 Why use Excel SUMIFS instead of SUMIF
01:20 Excel SUMIF function
03:10 Excel SUMIFS function
06:06 SUMIFS with wildcards
06:47 SUMIFS with comparison operators
09:17 Excel AVERAGIFS function
09:43 Excel COUNTIF function
10:19 Excel COUNTIFS function
11:50 How to use Excel Tables for dynamic referencing
13:31 Wrap Up
⯆ Download the workbook here: https://www.xelplus.com/sumifs-countifs-averageifs/
In this video I will show you a SUMIFS example and explanation. AVERAGEIFS works in the same way.
COUNTIFS function is shorter than SUMIFS and AVERAGEIFS because it doesn’t need the additional sum range. It only needs the criteria range. It counts the number of times the criteria is met.
Not sure if you should use SUMIF or SUMIFS? Stick to SUMIFS. This way you're on the safe side. In case you ever need to add more criteria, you can just expand on the arguments inside the formula. If you used SUMIF, you actually have to replace it with SUMIFS.
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
-
54:45
LFA TV
1 day agoWhat to Expect From Britain’s New Obama-Influenced Government| Trumpet Daily 7.8.24 9pm EST
49.6K13 -
46:19
Candace Owens
11 hours agoBOMBSHELL: Is Diddy A Fed Asset? | Candace Ep 20
54.3K91 -
1:40:37
Glenn Greenwald
10 hours agoBiden Cannot Be Forced Out of Race Democratically by Oligarchs; What the U.K. and French Elections Mean for Establishment Politics in Europe | SYSTEM UPDATE #293
107K252 -
1:57:57
Donald Trump Jr.
14 hours agoThe Left Lashes Out, Biden Defiant Against Dems’ Wishes | TRIGGERED Ep.152
156K474 -
2:32:23
WeAreChange
9 hours agoProsecutors LET Epstein Have Sex With Children! Will Trump Release THE FILES?
78.7K42 -
1:10:00
Matt Kim
10 hours agoIt's OUR Fault | Did the Conservatives FAIL society? | Matt Kim #104
84K36 -
43:43
Kimberly Guilfoyle
14 hours agoBiden Defies Dems’ Dropout Demands, Plus Climate Alarmism & Border Madness, Interviews with Alex Epstein & Abe Hamadeh | Ep. 140
82.1K55 -
59:06
The Amber May Show
13 hours agoSteve Gruber| Real America's Voice| War On Farming| Sex Slaves Modern Day Slavery
48.8K3 -
13:52
China Uncensored
9 hours agoChina Thought It Had the Perfect Weapon. Then It Lost Control
48K13 -
1:08:32
Redacted News
12 hours agoBREAKING! A COUP in Washington! WALLS closing in on Biden | Redacted w Natali and Clayton Morris
154K300