Sprinkler Systems Uhaul move Lawn care Roses and trees Ford Parts Chrysler Parts Lake Powell New IPod Touch Apps New IPhone Apps IPhone Apps IPad Information IPad Apps Android APPS Android Games APPS Android Systems Android Tablets APPS and Beyond Smartphone Apps Smartphone Games Apps Repair and Tools Tablet PC Car Sharing Car Leasing Tabler Pc Fly Fishing Toyota Cars Vacation Rentals Stock market NYSE SSE Stock Freight & Shipping News Gluten Lactose Gout My Coupon Life Campgrounds Check Outdoor Kitchen Design and Redoo Bath Remodeling Palm Springs Las Vegas Vacation Tipps Lake Powell Boating Homes for lease Electric and green Car Blog Pearls and diamonds Whatsapp and forget SMS Blog, What is Whatsapp App Renovation Blog Condo for rent or lease Solar Panel Solar Energie Sun Power Blog Truck for Sale Reconstruction Blog
Reader


[Suche]  [Administrator]  [Hinweise zum Reader]  [Startseite]
Computers » microsoft.public.cn.office » 怎样做有条件地统计数据
怎样做有条件地统计数据 [message #169207] Fr, 03 Mrz 2006 10:19
12star  
如何按指定条件去统计数据的个数呢?
我使用过这个函数
COUNT(IF(A2:A53=100,100))
就是A2至A53中等于100的数据的个数
我要在下面作一个统计,统计100的有多少个,50 有多少个这样,不使用自动筛选可以吗？
我使用上面的函数时在对话框中显示的结果是 正确的,但在单元格里就变成了0
Re: ͳ [message #169236 ] Mi, 08 Mrz 2006 04:18
wangjun  
COUNTIF
"12-star" <12star [at] discussions.microsoft.com> дϢ:CB45F998-8A44-4A3C-86E4-D989C61FE09B [at] microsoft.com...
> ΰָȥͳݵĸ?
> ʹù
> COUNT(IF(A2:A53=100,100))
> A2A53е100ݵĸ
> Ҫһͳ,ͳ100жٸ,50жٸ,ʹ Զɸѡ
> ʹĺʱڶԻʾĽȷ,ڵԪ ͱ0
Vorheriges Thema:RE: 如何去掉word页眉中的横线
Nächstes Thema:office_2003_sp2
Gehe zu:
  


aktuelle Zeit: Fr Mai 25 22:12:41 CEST 2012

Insgesamt benötigte Zeit, um die Seite zu erzeugen: 0,02325 Sekunden
.:: Startseite - Hinweise - Impressum ::.

Powered