COUNTIFS use in Complicated Data in Excel | Count Grade Students with Countifs Formula (Very Useful)

Raw Data

student marksheet data in excel


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

student marksheet data in excel summery report

Video Tutorial


Download Practice File



Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group
Nazim Khan - Author Image

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 ( 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.

1 thought on “COUNTIFS use in Complicated Data in Excel | Count Grade Students with Countifs Formula (Very Useful)”

Leave a Comment