<![CDATA[虫虫的blog SINCE2004]]> http://www.zhenghe.biz/index.php zh-cn http://www.zhenghe.biz/read.php/.htm <![CDATA[excel]]> 网络毛毛虫 <admin@yourname.com> Mon, 28 Jan 2013 12:13:52 +0000 http://www.zhenghe.biz/read.php/.htm 条件求和
=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))

]]> http://www.zhenghe.biz/read.php/.htm#blogcomment <![CDATA[[评论] excel]]> <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 http://www.zhenghe.biz/read.php/.htm#blogcomment