sumif/Countif

[Tom G]

I need to modify this formula:

=SUMIF(GRADE,7,A_D)/COUNTIF(GRADE,7)

so that the SUMIF is for Grade 7 AND School 10 and the COUNTIF is for Grade
7 AND School 10.

Any assistance will be appreciated.

Thanks

Tom

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(GRADE=7),--(SCHOOL=10),A_D)/SUMPRODUCT(--(GRADE=7),
--(SCHOOL=10))


where GRADE, SCHOOL and A_D all have the same dimensions.

Another way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=AVERAGE(IF((GRADE=7)*(SCHOOL=10),A_D,""))