第1个回答 2013-09-25
E4=SUMIF(H3:FM3,"发货",H4:FM4)
F4=SUMIF(H3:FM3,"退货",H4:FM4)
G4=SUMIF(H3:FM3,"销货",H4:FM4)
发货、退货、销货这些标题不要使用ALT+ENTER强制换行,否则公式要该为
E4=SUMIF(H3:FM3,"发"&CHAR(10)&"货",H4:FM4)
F4=SUMIF(H3:FM3,"退"&CHAR(10)&"货",H4:FM4)
G4=SUMIF(H3:FM3,"销"&CHAR(10)&"货",H4:FM4)