MS Excel Tutorial - Session 19 - Count, Counta, CountIf, SumIf, and AverageIf functions
Welcome to Session 19 of the MS Excel Tutorial series by ChiPi Technologies.
In this session, we focus on some of the most useful statistical and conditional functions in Excel: COUNT, COUNTA, COUNTIF, SUMIF, and AVERAGEIF.
These functions are the backbone of data analysis in Excel. They allow you to count, sum, and average values with or without conditions, making your spreadsheets smarter and more efficient. Whether you are working with student marks, sales reports, or large datasets, mastering these functions will save you time and effort.
📝 What You Will Learn in This Session:
COUNT Function
Count only numeric values in a range.
Use cases: student scores, salaries, or quantities.
COUNTA Function
Count all non-empty cells (including text).
Use cases: attendance tracking, customer records, or employee names.
COUNTIF Function
Count cells that meet a specific condition.
Examples: counting students who passed, sales above a target, or products in stock.
SUMIF Function
Add values that satisfy a condition.
Examples: total sales for a region, marks above 50, or expenses of a category.
AVERAGEIF Function
Calculate the average of values that meet a condition.
Examples: average marks of passing students, average sales above target, etc.
Practical Demonstrations
Real-world examples with datasets.
Step-by-step usage of each function.
Avoiding common mistakes.
🎯 Why This Session is Important?
These functions are critical for data analysis and reporting. After this session, you’ll be able to:
✔ Count records accurately with or without conditions.
✔ Apply conditional sums and averages in reports.
✔ Automate repetitive calculations.
✔ Build the foundation for advanced Excel formulas and analytics.
They are widely used in business reports, academic projects, and professional dashboards.
🌐 About ChiPi Technologies
At ChiPi Technologies, we are dedicated to teaching practical digital skills that bring real value to learners. Our tutorials are not just theoretical lessons — they are step-by-step guides to applying Excel in academic, professional, and business contexts.
We strongly believe that education should be accessible, affordable, and empowering. That’s why our mission is built on Affordable Education For All, making sure learners across the world can gain high-quality digital skills without worrying about heavy costs.
With ChiPi Technologies, you’re not just learning Excel functions — you’re preparing for career growth and data-driven opportunities.
📚 Who Should Watch This Video?
Students learning Excel for assignments and exams.
Professionals preparing business or financial reports.
Job seekers practicing Excel-based test questions.
Data enthusiasts exploring analytics basics.
Anyone who wants to analyze data quickly and effectively in Excel.
🚀 Why Learn Excel with Us?
When you choose ChiPi Technologies, you get:
✔ Tutorials explained in simple, beginner-friendly language.
✔ Real-world examples to make concepts easy to understand.
✔ A structured learning journey — from basics to advanced functions.
✔ Training that is affordable, globally accessible, and career-oriented.
We make Excel not just a tool, but a skillset you can proudly showcase in academics, jobs, and business.
🔔 Stay Connected
👉 Subscribe to our channel for upcoming Excel tutorials.
👉 Like and share this video with classmates, friends, or colleagues.
👉 Comment your doubts, and we’ll guide you step by step.
At ChiPi Technologies, we are building a community of learners where knowledge is shared freely and digital education is within reach for everyone.
✨ With this Session 19 – COUNT, COUNTA, COUNTIF, SUMIF, and AVERAGEIF Functions, you’ll learn how to make Excel an intelligent tool for data analysis and reporting. These formulas bring logic and automation into your spreadsheets, making them far more powerful.
At ChiPi Technologies, we continue our mission of Affordable Education For All, ensuring that every learner — whether a student, job aspirant, or working professional — can build skills to succeed in today’s digital world.