Sheet 1 to Display the count of items from Sheet 2

[Kishore_t_79]

Sheet 1 :
Grade Male Female
Primary
Secondary
High School
College
Gender

Sheet 2 :
Col A : Student Id
Col B: Gender : Here we specify whether the student is male or female
Col C : Here we specify category to which the student falls : Primary, secondary, high school, college
Col D : Age : To which age they are in

Problem :

In Sheet 1,
# I should give the count of students who are male and in
* primary and they are between 4 to 6 years.
* Count of Secondary students and between 6 to 10 years ...

# I should give the count of students who are female and in
* primary and they are between 4 to 6 years.
* Count of Secondary students and between 6 to 10 years

[popipipo]

Have you tried a pivot table to solve it?

[Kishore_t_79]

PIVOT will not solve the problem. I need to satisfy multiple condition

[Kishore_t_79]

Can any one help me ?