# Get instant live expert help on sum index match

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I need a formula help on index match, sum if
Solved by O. S. in 11 mins
I'm trying to use something, like index/match, to find data then sum it across rows
Solved by M. F. in 13 mins
What does this formula in April b5 mean =INDEX(C7:AF7,SUM(-1, MATCH(TRUE,INDEX(ISBLANK(C7:AF7),0),0))) - June!AF7
Solved by D. F. in 11 mins
=INDEX(D48:E69,MATCH(E74,D74:D95,FALSE)2,2) Need help with index and match
Solved by C. L. in 17 mins
If you are not the person who wrote this INDEX(Sheet2!A:A,small(IF("N"=INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19),ROW(INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19))-ROW(INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19),1,1)+1),1)) then dont think you can fix it. route it to him who wrote it.
Solved by F. F. in 28 mins