=SUMPRODUCT(N(INDIRECT(TEXT(MID(A1,{1,2,3,4,5},1),"""Sheet""0!!u25;;;""sheet1!u25"""))))-Sheet1!U25*(5-LEN(A1))

这个题才让我晕
http://zhidao.baidu.com/question/185048137.html

上面弄复杂了
=SUMPRODUCT(N(INDIRECT("sheet"&MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)&"!U25")))

回复：4楼
EXCEL中，公式太长！详细解决方法？差不多每都不相同。用X=某某和数组应不行吧
悬赏分：0 - 解决时间：2010-9-19 20:39
=if(a1=1,sum(sheet1!u25),if(a1=2,sum(sheet2!u25),if(a1=3,sum(sheet3!u25),if(a1=4,sum(sheet4!u25),if(a1=5, sum(sheet5!u25), if(a1=6, sum(sheet6!u25), if(a1=7, sum(sheet7!u25), if(a1=12, sum(sheet2!u25, sheet1!u25), if(a1=13, sum(sheet3!u25, sheet1!u25), if(a1=14, sum(sheet4!u25, sheet1!u25), if(a1=15, sum(sheet5!u25, sheet1!u25), if(a1=16, sum(sheet6!u25, sheet1!u25), if(a1=17, sum(sheet7!u25, sheet1!u25), if(a1=23, sum(sheet2!u25,sheet3!u25), if(a1=24, sum(sheet2!u25, sheet4!u25), if(a1=25, sum(sheet2!u25, sheet5!u25), if(a1=26, sum(sheet2!u25, sheet6!u25), if(a1=27, sum(sheet2!u25, sheet7!u25), if(a1=34, sum(sheet4!u25,sheet3!u25), if(a1=35, sum(sheet5!u25,sheet3!u25), if(a1=36, sum(sheet6!u25,sheet3!u25), if(a1=37, sum(sheet7!u25,sheet3!u25), if(a1=45, sum(sheet5!u25, sheet4!u25), if(a1=46, sum(sheet6!u25, sheet4!u25), if(a1=47, sum(sheet7!u25, sheet4!u25), if(a1=56, sum(sheet6!u25, sheet5!u25), if(a1=57, sum(sheet7!u25, sheet5!u25), if(a1=67, sum(sheet7!u25, sheet6!u25)..............................................................................
问题补充：不好意思！缺少一句话，当选1时就删了SHEET2，3，4，5，6，7表。当选23时就删了SHEET1，4，5，6，7表