About Course
Learn to total, count and average data that meets several conditions at once using SUMIFS, COUNTIFS and AVERAGEIFS. You will write criteria with text, numbers, dates, operators and wildcards, and learn the mistakes that cause wrong answers.
This course is general training. Menu names and features can differ between Excel for Microsoft 365, Excel 2021/2024, older versions, Mac and Excel for the web, so check Microsoft Support for your version. Tutwoo is independent and not affiliated with Microsoft.
Course Content
Course Lessons
-
Why use the “IFS” functions?
-
Writing criteria: text, numbers, operators and wildcards
-
COUNTIFS and AVERAGEIFS in practice
-
Building a summary table and avoiding mistakes
Sources & Further Reading
Final Assessment
Student Ratings & Reviews
No Review Yet