条件求和
=SUMIF('500-1000万'!C:C,"自助委托",'500-1000万'!D:D)/10000
=SUMIF('500-1000万'!C:C,"热键委托",'500-1000万'!D:D)/10000
=SUMIF('500-1000万'!C:C,"网上无证",'500-1000万'!D:D)/10000
=SUMIF('500-1000万'!C:C,"集中电话",'500-1000万'!D:D)/10000
=SUMIF('500-1000万'!C:C,"手机委托",'500-1000万'!D:D)/10000
A列不同数字统计个数
=COUNT(1/FREQUENCY(a:a,a:a))