|
本帖最后由 baksy 于 2014-2-18 22:11 编辑
复制公式,三键回车( 先按住 shift、ctrl 两个键,然后敲 enter 键 )
C23 =SUM(IF(LEFT(RIGHT(原始表格!H3:H421,18),3)<>"500",1))
G23 =SUM((LEFT(RIGHT(原始表格!$H$3:$H$421,18),3)<>"500")*(LEFT(原始表格!$B3:$B421,6)=E20))
K23 =SUM((LEFT(原始表格!$B3:$B421,6)=I20)*(LEFT(RIGHT(原始表格!$H$3:$H$421,18),3)<>"500"))
O23 =SUM((LEFT(原始表格!$B3:$B421,6)=M20)*(LEFT(RIGHT(原始表格!$H$3:$H$421,18),3)<>"500"))
|
|