IF/AND I am trying to create an IF(AND function and am having difficulty. I am t

Question

IF/AND

I am trying to create an IF(AND function and am having difficulty. I am trying to calculate averages for various student subpopulations to compare them with the entire student body. If any of the students have the text "IEP" in E7:E36 (note: it will either have "IEP" in the cell or be blank), and have scores listed in K7:K36, then those students' scores in K7:K36 should be averaged. If either of those columns does not have data entered, then its shouldn't be included in the average. If no students meet the above qualifications, then I'd like an empty ("") cell to appear, rather than ##DIV/0. Thank you for your help!!!.   

Explanation / Answer

Try this

=IFERROR(AVERAGEIF(E7:E36,"IEP",K7:K36),"")

HTH.!!

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects