您的位置 首页 WPS教程

如何在Excel中统计大于0的个数

计算机统计现在这么的方便,给人们在工作方面带来了很大的便利,就比如对于统计那些大于零的数值,如果数字太多还需要一个一个去数就会比较麻烦,并且在数的过程中也会因为太多造成眼花而容易出现问题。那么如何能通过excel直接统计出来呢?

首先,我们可以直接在单元格B1中输入COUNTIF函数,因为COUNTIF函数表示的是对于一些特定区域中符合特定条件标准的单元格计数的一个函数,然后我们需要输入【=COUNTIF(A:A,”>0″)】这一公式,接着就可以按Enter键了:

>>免费升级到企业版,赠超大存储空间

按下之后就能够得出这些数值中大于零数值的数量是多少了:

>>免费升级到企业版,赠超大存储空间

如果到这里还没有看懂的朋友,可以自己去打开excel尝试一下,先随意打几个数字出来,按照我刚刚说的方法输入公式来进行计算,得出来的结果一定是又快又准。那么,在Excel表格技巧中,Excel统计大于0的个数的方法是不是非常简单呢,你学会了吗?

热门文章

发表评论

邮箱地址不会被公开。

48条评论

  1. Hmm it looks like your website ate my first comment (it was extremely long) so I guess I’ll just sum it up
    what I had written and say, I’m thoroughly enjoying your
    blog. I too am an aspiring blog writer but I’m
    still new to the whole thing. Do you have any tips for beginner blog writers?
    I’d really appreciate it. 0mniartist asmr

  2. hey there and thank you for your info – I have definitely picked up something new from right here.
    I did however expertise some technical points using this
    web site, as I experienced to reload the site a lot of times previous to I could
    get it to load properly. I had been wondering if your web hosting
    is OK? Not that I am complaining, but slow loading instances times will sometimes affect your placement in google and
    could damage your high-quality score if advertising and
    marketing with Adwords. Well I am adding this RSS to my email and could
    look out for a lot more of your respective exciting content.
    Ensure that you update this again soon. asmr 0mniartist

  3. Hi there, I discovered your site by the use of Google at
    the same time as searching for a similar subject, your web site got here up, it seems great.
    I have bookmarked it in my google bookmarks.
    Hello there, just become aware of your blog via Google, and
    located that it is really informative. I’m gonna watch out
    for brussels. I’ll appreciate for those who proceed this in future.
    Many folks will probably be benefited out of your writing.
    Cheers! asmr 0mniartist

  4. Wow, awesome blog format! How lengthy have you ever been running a blog
    for? you made blogging glance easy. The full glance of your
    site is excellent, as neatly as the content!

  5. For hottest information you have to pay a quick visit world wide web and
    on internet I found this website as a best web page for latest updates.

  6. Ahaa, its fastidious dialogue concerning this post here at this webpage, I have read all that,
    so now me also commenting at this place.

  7. Hello my family member! I want to say that this post is awesome, great written and come with approximately all significant infos.
    I’d like to peer extra posts like this .

  8. Wow, awesome blog layout! How long have you been blogging for?
    you make blogging look easy. The overall look of your web site
    is fantastic, let alone the content!

  9. I must thank you for the efforts you have put in writing this site.
    I’m hoping to see the same high-grade blog posts by
    you in the future as well. In fact, your creative writing abilities has inspired me to get my own, personal website
    now 😉

  10. I was suggested this blog by my cousin. I’m not sure whether this post
    is written by him as no one else know such detailed
    about my difficulty. You’re incredible! Thanks!

  11. Hi, I do think this is an excellent web site.

    I stumbledupon it 😉 I will return once again since i
    have bookmarked it. Money and freedom is the greatest way to
    change, may you be rich and continue to guide other
    people.

  12. scoliosis
    Admiring the dedication you put into your blog
    and in depth information you present. It’s nice to come across
    a blog every once in a while that isn’t the same unwanted rehashed information. Excellent read!
    I’ve saved your site and I’m adding your RSS feeds
    to my Google account. scoliosis

  13. Pingback: free married dating
  14. free dating sites
    Hello there! I know this is kinda off topic
    nevertheless I’d figured I’d ask. Would you be interested in exchanging links or maybe guest writing a blog post or vice-versa?
    My blog covers a lot of the same topics as yours and I feel we could greatly benefit
    from each other. If you might be interested feel free to
    send me an e-mail. I look forward to hearing from
    you! Wonderful blog by the way! free dating sites

  15. I love your blog.. very nice colors & theme. Did
    you make this website yourself or did you hire someone to do it for
    you? Plz reply as I’m looking to design my own blog and would like to find out where u got this from.
    appreciate it

  16. We’re a group of volunteers and starting a new scheme in our community.

    Your site provided us with valuable information to
    work on. You’ve done a formidable job and our whole community will be grateful to you.

  17. magnificent issues altogether, you just gained a brand new reader.

    What may you suggest about your publish that
    you simply made a few days in the past? Any positive?

  18. Hello! Quick question that’s entirely off topic.

    Do you know how to make your site mobile friendly?
    My weblog looks weird when viewing from my iphone 4.
    I’m trying to find a theme or plugin that might be able to
    resolve this problem. If you have any suggestions, please share.
    Thanks!

  19. Pingback: free uk adult dating
  20. I do accept as true with all the concepts you’ve introduced in your
    post. They are really convincing and will definitely work. Nonetheless, the posts are
    very brief for newbies. Could you please prolong them a bit from next
    time? Thanks for the post.