Raw Data
1 Introduction
In the below video I have explained how to count the total Grade of Each student for each subject.
2 Purpose
To Extract Summary Data from A Big Data of Students of Multiple classes and sections Grade-wise and Subject-wise. We have generated a Simple and quick MIS Report for School or College.
3 Command Used
To solve this problem, we have used the COUNTIFS formula in Excel. which is a very helpful formula. but the use of Dollar Sign is a little bit complicated in this sheet, but you can watch the video again and again to learn. I have entered the formula below, you can copy and paste it into your sheet and the Excel file download link is also given below.
Formula: =COUNTIFS(DATA!$G:$G,’Final Data’!$B3,DATA!$L:$L,’Final Data’!C$2)
Also Learn: Use of Dollar Sign in Excel (in Hindi)
Final Report
Video Tutorial
Download Practice File
More Important for You:
1. How to use Indirect Formula in Excel
2. How to use Forecast Formula in Excel in (Hindi)
3. Excel Magic Formula in Hindi
4. Excel में Income Tax Calculator बनाना सीखें
Join Our WhatsApp Group
Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]
Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.
Very nice