SHEET1:a1:a5为:1,2,3,4,5;b1:b5为:a,b,c,d,e SHEET2:a1:a5为:1,2,3,4,5;b1输入:=sum(if(sheet1!a1:a5=a1,sheet1!b1:b5,"")),记住是数组,即输入完后按ctrl+enter,再看公式会变成:={sum(if(sheet1!a1:a5=a1,sheet1!b1:b5,""))} 解答2:比如sheet1中,数据在a1:b5 .sheet2中,3在a1,在a2中输入公式:=vlookup(a1,sheet1!$a$1:$b$5,2,false)然后按着shift键把下面的单元格选中,再按ctrl+d将公式复制下去就搞定了!如果对公式不熟悉,可以采用公式向 |