Sumif+Large Functions Wont Work Together

Hi there,

I have a formula that should work perfectly, and I can't seem to figure out why it wont.

Goal: To sum the largest ranked cells in an array. However, I'm summing cells based on a criteria (the rank) in other cells. And I only want to sum the cells if all the ranks in the corresponding row >= to 45.

Formula: =IF(SUM($B4:$L4)>=45,SUMIF($B4:$L4,LARGE($B4:$L4,{1,2,3}),$Z4:$AJ4))

As you can see in the attached workbook, if the sum of the ranks >=45, then excel is only taking the FIRST cell in the array I want summed.

Can anyone see what the issue is?

That would take the sum of the ranges, not the sum of the adjusted log changes

Thank you so much. Any idea why that worked and the other one didn't?

Got it. Thanks a lot for your help!!