I'm trying to use a different sheet by using importrange. Would you please check why my formula is not working?
=IFERROR(INDEX(IMPORTRANGE("Link Name""Tab Name!$E$1715:$E$1762"),SUMPRODUCT(((IMPORTRANGE("Link Name""Tab Name!$B$1715:$B$1762")=$B123)*((IMPORTRANGE("Link Name""Tab Name!$M$1715:$S$1762")=AR$9)*(ROW((IMPORTRANGE("Link Name""Tab Name!$E$1715:$E$1762"))))-ROW((IMPORTRANGE("Link Name""Tab Name!$E$1715"))+1),"")))))
=IFERROR(INDEX(IMPORTRANGE("Link Name""Tab Name!$E$1715:$E$1762"),SUMPRODUCT(((IMPORTRANGE("Link Name""Tab Name!$B$1715:$B$1762")=$B123)*((IMPORTRANGE("Link Name""Tab Name!$M$1715:$S$1762")=AR$9)*(ROW((IMPORTRANGE("Link Name""Tab Name!$E$1715:$E$1762"))))-ROW((IMPORTRANGE("Link Name""Tab Name!$E$1715"))+1),"")))))