How to count data from an array with a certain condition?

Question

Google Sheets

=COUNTIFS(B:B; "Nike"; C:C; "L"; D:G; "green")
Array arguments have different

sizes array)?

Answer 1

The simplest solution:

=СЧЁТЗ(ЕСЛИОШИБКА(FILTER(A:A;B:B="Nike";C:C="L";D:D="зеленый");0))+
  СЧЁТЗ(ЕСЛИОШИБКА(FILTER(A:A;B:B="Nike";C:C="L";E:E="зеленый");0))+
  СЧЁТЗ(ЕСЛИОШИБКА(FILTER(A:A;B:B="Nike";C:C="L";F:F="зеленый");0))+
  СЧЁТЗ(ЕСЛИОШИБКА(FILTER(A:A;B:B="Nike";C:C="L";G:G="зеленый");0))

Answer 2

Possible variant

=ARRAYFORMULA(QUERY(
  SPLIT(FLATTEN(B2:B6 & "♡" & C2:C6 & "♡" & D2:G6);"♡");
  "select Col1, Col2, Col3, count(Col3) 
   where Col3 is not null 
   group by Col1, Col2, Col3 label count(Col3)''"
))

https://docs.google.com/spreadsheets/d/1ziMImIx8Gc...