I know how to use sumif with array formula in this way: =ARRAYFORMULA(sumif(F3:F10,A3:A6,J3:I10))

But when I try to use greater than or less than signs, it doesn't work: =ARRAYFORMULA(sumif(F3:F10&H3:H10&I3:I10,A3:A6&">"&B3:B6&"<"&B3:B6,J3:J10))

Sample:

or:

=ARRAYFORMULA(VLOOKUP(A3:A6&TEXT(B3:B6, "00000"), 
 SORT({F:F&FILTER(TEXT(H:H, "00000"), H:H<>""), J:J}), 2, 1))