=averageif( ) with multiple critieria

The Data provided is insufficient.

upload a sample workbook without any confidential data. and also show the desired result manually.

Punnam

I am attaching a file per your request...

Hi ,

I am really confused with data provided .Clarify the below points
1) Where did you like to have the formula
2) Show the expected results Manually & Color them for your identification
3) As said ESL & SPED ,i am unable to find SPED in any of your master data , any cell reference for example will be help full .

Punnam

Allow me to clarify. I was simplifying what I wanted for I just wanted to learn the code and then figure it out. Yet, I made a template of how I want it.

The data comes up with the student ID, Student Name, Class Period, Class Code, Teacher Name. Then we have columns that tell us if the student is SPED, LEP, GT, and their Ethnicity. The students are indentified as "1" if they are SPED, LEP, GT or "0" if they are not. I ignore Ethnicity. I just put there in case someone ask for an analysis later on. I put the template how I want the data.

I want averages of how the teacher did overall, how they did by class, and how the students that are SPED, LEP, GT averaged in that class.

StudentId Student Meets Class Code Teacher SPECIAL_ED LEP GT ETHNICITY 8 ELA DIAG 08.06.A 08.06.B 08.06.C

Damon

Allow me to clarify. I was simplifying what I wanted for I just wanted to learn the code and then figure it out. Yet, I made a template of how I want it.

The data comes up with the student ID, Student Name, Class Period, Class Code, Teacher Name. Then we have columns that tell us if the student is SPED, LEP, GT, and their Ethnicity. The students are indentified as "1" if they are SPED, LEP, GT or "0" if they are not. I ignore Ethnicity. I just put there in case someone ask for an analysis later on. I put the template how I want the data.

I want averages of how the teacher did overall, how they did by class, and how the students that are SPED, LEP, GT averaged in that class.

StudentId Student Meets Class Code Teacher SPECIAL_ED LEP GT ETHNICITY 8 ELA DIAG 08.06.A 08.06.B 08.06.C

Damon

Hi Damonjasso ,

I have updated the sheet with average for "StudentId Student Meets Class Code Teacher SPECIAL_ED LEP GT " based on these
but for "ETHNICITY 8 ELA DIAG 08.06.A 08.06.B 08.06.C" what is the other cretia ?
Punnam

You are my hero! Can I make a donation to you?

DAMON

HI damonjasso ,

Thanks you , no need any donation , as you are willing to donate i will suggest you one thing,
The forum is having division Named "Commercial Services" , In case of fast and more appropriate solution you can post your thread in that division where you need yo pay amount in therms of points .
Apart of this you can add me some reputation points by clicking the TAB "ADD Reputation" this is other way of staying thanks in this forum.
Punnam