The SUMIF, SUMIFS, AVERAGEIF, and AVERAGEIFS Functions in Excel
HTML-код
- Опубликовано: 21 авг 2024
- This video demonstrates how to use the SUMIF, SUMIFS, AVERAGEIF, and AVERAGEIFS functions in Microsoft Excel. The SUMIF and AVERAGEIF functions add and average cells specified by one condition, and the SUMIFS and AVERAGEIFS work with multiple conditions.
I’ve been watching your psych videos for so long and I was beyond excited when I saw that you have all of the Excel functions explained, I need this for uni now and I love the way you explain everything, thank you for all of the great videos, both psych and Excel related ☺️☺️☺️☺️
I watched this specific video because sums and means are used so frequently in analysis I wanted to learn the difference between SUMIF and SUMIFS and AVERAGEIF and AVERAGEIFS. It surprised me how easy it is to eliminate outliers or specific criteria in excel analysis.