求助大佬，有没有什么函数能将下列函数公式简化
=SUM(IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!$A$2&"!B:K"),9,0),0),IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!A3&"!B:K"),9,0),0),IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!A4&"!B:K"),9,0),IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!A5&"!B:K"),9,0),IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!A6&"!B:K"),9,0),IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!A7&"!B:K"),9,0),IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!A8&"!B:K"),9,0),IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!A9&"!B:K"),9,0),0)))))))
=SUM(IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!$A$2&"!B:K"),9,0),0),IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!A3&"!B:K"),9,0),0),IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!A4&"!B:K"),9,0),IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!A5&"!B:K"),9,0),IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!A6&"!B:K"),9,0),IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!A7&"!B:K"),9,0),IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!A8&"!B:K"),9,0),IFERROR(VLOOKUP($A$5,INDIRECT(PCBA!A9&"!B:K"),9,0),0)))))))
