sumif/Countif

  • Thread starter Thread starter Tom G
  • Start date Start date
T

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
 
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,""))
 
Back
Top