Excel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria)
Quickly learn how SUMIFS & COUNTIFS formulas work - and why they are better than SUMIF & COUNTIF formulas.
Download the workbook here: https://www.xelplus.com/sumifs-countifs-averageifs/
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.
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
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
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 SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria) канала Leila Gharani
Download the workbook here: https://www.xelplus.com/sumifs-countifs-averageifs/
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.
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
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
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 SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria) канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
INDEX MATCH Explained (An Alternative to VLOOKUP)Create SMART Drop Down Lists in Excel (with Data Validation)Excel Sum(ifs) between dates, sum month & sum with multiple criteria15 Expert SUMIFS Function Examples in Excel - Simple to Advanced - Workbook Included50 Ultimate Excel Tips and Tricks for 2020Pivot Table with Progress Chart and DashboardExcel shortcut keys you SHOULD know!Excel SUMIFS: Sum Alternate Columns based on Criteria and HeaderHow to use COUNTIF and COUNTIFS in Microsoft Excel4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examplesIntroduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)Top 25 Excel 2016 Tips and TricksExcel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCTBuild Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)Excel: How to Best Import External Data into Excel & Import data from the Web to ExcelExcel Magic Trick 1024: SUMIF & SUMIFS function & Mixed Cell References & Dynamic Table RangeLookup values across multiple worksheets: VLOOKUP / INDEX MATCH in ExcelHow to use Excel Index Match (the right way)