One more

=SUM(INDEX((--RIGHT(B$1:G$1)<=B$6)*(B2:G2),0))