Coluna 1:

Formula: =BDMÉDIA(B2:F17;C2;I4:I5)

Coluna 2:

Formula: =BDSOMA(B2:F17;F2;I7:J8)

Coluna 3:

Formula: =BDCONTARA(B2:F17;B2;I10:I12)

Coluna 4:

Formula: =BDCONTARA(B2:F17;B2;I14:J15)

Coluna 5:

Formula: =BDMÉDIA(B2:F17;C2;I17:J18)

Coluna 6:

Formula: =BDSOMA(B2:F17;F2;I20:J22)

Coluna 7:

Formula: =BDSOMA(B2:F17;F2;I24:J26)

Coluna 8:

Formula: =BDCONTARA(B2:F17;B2;I28:J31)

Coluna 9:

Formula: =BDMÉDIA(B2:F17;D2;I33:J36)

Coluna 10:

Formula: =BDSOMA(B2:F17;F2;I38:J40)