=SUMPRODUCT((A1:A6="吴2")+(A1:A6="李2")*E1:E6)
想学习excel到这里面看看就会了http://club.excelhome.net/forum.php?mod=viewthread&tid=495330&extra=page%3D1&page=1&&jdfwkey=0nil73
=SUMPRODUCT((A1:A6={"李2","吴2"})*E1:E6)
