Hi, Try this.

=AVERAGEIF($F$4:$F$43,"D",$BM$4:$BM$43)