Array arguments to SUMIFS are of different size, clarification needed

Question

As you can see from the below snippet arrays are of the same size

=SUMIFS(
           $J$12:$J$38,
   ">=0",  $K$12:$K$38,
   "="&Y47,$M$12:$M$38
)

Yet, I am getting an error Array arguments to SUMIFS are of different size.

Please help me understand what is missing here.

Answer 1

The sum range is the first parameter of the function, not the last. Please try

=SUMIFS($M$12:$M$38, $J$12:$J$38, ">=0",  $K$12:$K$38, "="&Y47)

and see if that works?

REFERENCE:

• SUMIFS()