zhendeaini

参考：
=IF(ISERROR(INDEX($A$2:$A$977,MATCH(0,COUNTIF(N$1:N1,$A$2:$A$977),0))),"",INDEX($A$2:$A$977,MATCH(0,COUNTIF(N$1:N1,$A$2:$A$977),0)))，然后同时按Ctrl+Shift+Enter。[68]

zhendeaini

参考：
=IF(ISERROR(INDEX(INDIRECT("$A$2:$A$"& COUNTA(A:A)),MATCH(0,COUNTIF(N$1:N1,INDIRECT("$A$2:$A$"& COUNTA(A:A))),0))),"",INDEX(INDIRECT("$A$2:$A$"& COUNTA(A:A)),MATCH(0,COUNTIF(N$1:N1,INDIRECT("$A$2:$A$"& COUNTA(A:A))),0)))

zhendeaini

如果剔除空格，可以参考以下公式：
=IF(RIGHTB(I3,6)<>"滞纳金",SUMIFS(C:C,A:A,I3,B:B,"<>滞纳金"),SUMIFS(C:C,A:A,IF(ISERROR(LEFT(I3,FIND("滞",I3,1)-1)),I3,LEFT(I3,FIND("滞",I3,1)-1)),B:B,"滞纳金"))

话说，习惯使用Office 2003版本，很多新函数也在摸索中。[2]

zhendeaini

客气，或许你有更好的解决办法。多交流，多共享。[0]