Array formula SUMIF no responding

Copper Contributor


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)

Hi @Analytic_JCPS,


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






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


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