自动填充单元格

jasonforliu

<p>请教：</p><p><table cellspacing="0" cellpadding="0" width="508" border="0" style="WIDTH: 381pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="508" style="WIDTH: 381pt; mso-width-source: userset; mso-width-alt: 16256;"></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td width="508" height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 381pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">如果A列中的出口发票号与SHEET1 中E 列中的发票号一致时</font></td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;"><font face="宋体">能自动将SHEET1 中F 列中的发票金额导入到SHEET2中的B列对应的位置</font></td></tr></tbody></table>？</p><p>谢谢</p>

km560

如果发票号是唯一的话,可以这样试试,=sumif(A1:A,E1:Ex,f1:fx)