Maybe this...

=SUM(SUMIF(C:C,{"July","August","September"},D:D))/SUM(COUNTIF(C:C,{"July","August","September"}))