比如 sheet 1
证券代码 日期 年龄
000001 12/31/2000 53.43478
000001 12/31/2001 52.88462
000001 12/31/2002 52.57692
000001 12/31/2003 53.68
000001 12/31/2004 51.70833
000001 12/31/2005 51.53846
000002 12/31/2000 41.88
000002 12/31/2001 41.09091
000002 12/31/2002 41.68421
000002 12/31/2003 42.88889
000002 12/31/2004 43.6
000002 12/31/2005 44.04762
然后sheet 2
代码 日期 薪酬
000001 12/31/2001 790000
000001 12/31/2002 1300000
000001 12/31/2003 1660000
000001 12/31/2004 2290000
000001 12/31/2005 9686100
000002 12/31/2001 1310000
000002 12/31/2002 1410000
000002 12/31/2003 1770000
000002 12/31/2004 5150000
000002 12/31/2005 8180000
结果是
代码 日期 年龄 薪酬
000001 12/31/2000 53.43478
000001 12/31/2001 52.88462 790000
000001 12/31/2002 52.57692 1300000
000001 12/31/2003 53.68 1660000
000001 12/31/2004 51.70833 2290000
000001 12/31/2005 51.53846 9686100
000002 12/31/2000 41.88
000002 12/31/2001 41.09091 1310000
000002 12/31/2002 41.68421 1410000
000002 12/31/2003 42.88889 1770000
000002 12/31/2004 43.6 5150000
000002 12/31/2005 44.04762 8180000
在线等!
å设éè¦æSheet2ä¸å¯¹åºAãBåçèªèµè¡¥å å°Sheet1çDåï¼
1ãåå»Sheet1çD2åå æ ¼ï¼è¾å ¥å ¬å¼ï¼
=SUM((Sheet2!$A$2:$A$11=A2)*(Sheet2!$B$2:$B$11=B2)*Sheet2!$C$2:$C$11)
æ°ç»å ¬å¼ï¼æCtrl+Shift+Enter ç»æè¾å ¥ï¼
è§å¾ä¸
2ãéä¸Sheet1çD2åå æ ¼ï¼ä¸æå¡«å è³è¡¨æ ¼å çDåï¼å®é ç»æ
è§å¾äº
这个我已经试过了 结果是这样的 所以是错误的 麻烦你看看有什么方法改进的 谢谢啦
000001 12/31/2000 53.43478 790000 000002 12/31/2000 41.88 1310000
000001 12/31/2001 52.88462 790000 000002 12/31/2001 41.09091 1310000
000001 12/31/2002 52.57692 790000 000002 12/31/2002 41.68421 1310000
000001 12/31/2003 53.68 790000 000002 12/31/2003 42.88889 1310000
加510809100帮你在线解决,可能你的系统数据有问题
本回答被提问者采纳