=IF(ISNUMBER(VLOOKUP(E3,'1'!$C$3:$AY$96,14,0)),VLOOKUP(E3,'1'!$C$3:$AY$96,14,0)+VLOOKUP(E3,'1'!$C$3:$AY$96,15,0)+VLOOKUP(E3,'1'!$C$3:$AY$96,16,0)+VLOOKUP(E3,'1'!$C$3:$AY$96,17,0)+VLOOKUP(E3,'1'!$C$3:$AY$96,18,0),0)
引用不同的工作簿时使用[aaa.xls]sheet1!$a$1:$c$30