Welcome to the forum.

Maybe, assuming all those items at the end are named values,

=SUMIFS(M$6:M$900, 
        $B$6:$B$900, 1, 
        $F$6:$F$900, "Pinnacle", 
        $I$6:$I$900, Choose{1,2,3,4,5,6,7,8,9,10,11,12,1314,15,16,17,18,19,20,21}, 
                     CHI, CZE, DAN, FIN, FR, GE, GK, IT, JP, LAAM, NL, UK, NOR, POL, POR, RUS, SP, SWE, US, Autre, TUR))