En format numérique ET paramètres régionaux US
=ArrayFormula(Query(transpose(Query(TRANSPOSE({Query({BD!A1:UE1;to_text(Query({if(BD!A2:UE4>0,1,0)},"Select "&JOIN(",","Sum(Col"&column(BD!A1:UE1)&")")))},"Offset 1",1);BD!A2:UE4}),"Select * Where Col2<>'0'",1)),"Select * Offset 1",1))
Présenté verticalement, cela me parait plus lisible
=ArrayFormula(transpose(Query(transpose(Query(TRANSPOSE({Query({BD!A1:UE1;to_text(Query({if(BD!A2:UE4>0,1,0)},"Select "&JOIN(",","Sum(Col"&column(BD!A1:UE1)&")")))},"Offset 1",1);BD!A2:UE4}),"Select * Where Col2<>'0'",1)),"Select * Offset 1",1)))
c'est assez complexe, je vais quand même voir comment procéder plus simplement !