How to add Vlookup with countif Function

[vishwanathkumar.s]

Hi Mr.Chandoo,


Here is my Question, I need to identify the number of presents in my class as per their Class with Teacher name.


In Detail -


Sheet2 - Data looks like


Class,TeacherName,StudentName,PR,PR,SBL,PR


I need to find the out by the Class, Teacher Name, their number of presents & Absents

 

[Hui]

I'd use a sumproduct


Assuming your columns are like

A	B		C		D	E	F	G

Class	TeacherName	StudentName	PR	PR	SBL	PR

with something like

=SUMPRODUCT((A2:A15=ClassName)*(B2:B15=TeacherName)*(D2:D15=PresentValue))


adjust Columns and Range to suit