[求助]跨工作表筛选!!在不帮我,小弟就只要下岗了!

淼漫

E5=IF(ISERROR(VLOOKUP(B5,'891-0153'!$B$4E$11,4,FALSE)),0,VLOOKUP(B5,'891-0153'!$B$4E$11,4,FALSE))+IF(ISERROR(VLOOKUP(B5,'891-0349'!$B$4E$8,4,FALSE)),0,VLOOKUP(B5,'891-0349'!$B$4:$E$8,4,FALSE))+IF(ISERROR(VLOOKUP(B5,'692-0174'!$B$4:$E$8,4,FALSE)),0,VLOOKUP(B5,'692-0174'!$B$4:$E$8,4,FALSE))+IF(ISERROR(VLOOKUP(B5,'891-0088'!$B$4:$E$6,4,FALSE)),0,VLOOKUP(B5,'891-0088'!$B$4:$E$6,4,FALSE))+IF(ISERROR(VLOOKUP(B5,'891-0185'!$B$4:$E$6,4,FALSE)),0,VLOOKUP(B5,'891-0185'!$B$4:$E$6,4,FALSE))+IF(ISERROR(VLOOKUP(B5,'891-0073'!$B$4:$E$12,4,FALSE)),0,VLOOKUP(B5,'891-0073'!$B$4:$E$12,4,FALSE))

看看是否满足要求

情比金坚

先定义一下：然后数组：（b5用有效性——序列）

{=SUM((定额_0513=$B$5)*(定额_0349=$B$5)*(定额_0174=$B$5)*(定额_0088=$B$5)*(定额_0185=$B$5)*(定额_0073=$B$5))}

[此贴子已经被作者于2005-6-22 18:40:17编辑过]

淼漫

用数组，不错不错