SOLVED

# Array formula SUMIF no responding

Copper Contributor

# Array formula SUMIF no responding

Hello!

I insert an array formula in cell x40 down to x47 (sets as general format) looking for a specific word from a table m38 to t57, in order from number12 down to 6. Columns M, O Q, and S are numerical, and the text or words searched are in columns N, P, R, and T.

I'm taking data from a dynamic table, but in the other table just I need results in a column (x) bringing the highest first seven words in ascending order.

2 Replies
best response confirmed by Analytic_JCPS (Copper Contributor)
Solution

# Re: Array formula SUMIF no responding

You may trying using the below formula & it should work fine

``````=INDIRECT(ADDRESS(
MAX(IF(LARGE(\$M\$38:\$T\$57,\$W41)=\$M\$38:\$T\$57,ROW(\$M\$38:\$M\$57))),MAX(IF(LARGE(\$M\$38:\$T\$57,\$W41)=\$M\$38:\$T\$57,1+COLUMN(\$M\$38:\$T\$38))),1,1),TRUE)``````

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

# Re: Array formula SUMIF no responding

Hi Shaikh!
Thank you.
I appreciate a lot your help. The formula just fit fine and ease!!