Page 1 of 2 12 LastLast
Results 1 to 10 of 15
Like Tree1Likes

=COUNTIF(A1;A10.....value is greater than zero?

This is a discussion on =COUNTIF(A1;A10.....value is greater than zero? within the Excel Questions forums, part of the Question Forums category; Hi there, I am wondering how to finish this formula off, I want to count the number of cells in ...

  1. #1
    Board Regular
    Join Date
    Mar 2003
    Location
    Glasgow
    Posts
    114

    Default =COUNTIF(A1;A10.....value is greater than zero?

    Hi there,

    I am wondering how to finish this formula off,

    I want to count the number of cells in a list that have a value that is greater than zero?

    Many thanks,

    Graham.

  2. #2
    Board Regular
    Join Date
    Aug 2003
    Location
    England
    Posts
    4,722

    Default Re: =COUNTIF(A1;A10.....value is greater than zero?

    Hello,

    Does this suit your needs?

    =COUNTIF(A1:A10,">0")
    dozzydozz likes this.
    -------------------------
    Hope this is helpful.
    -------------------------

    Have been away from the forum for quite a while, but am now back.

  3. #3
    Board Regular
    Join Date
    Mar 2003
    Location
    Glasgow
    Posts
    114

    Default Re: =COUNTIF(A1;A10.....value is greater than zero?

    This is perfect....thankyou!

  4. #4
    New Member
    Join Date
    Jul 2010
    Posts
    1

    Default Re: =COUNTIF(A1;A10.....value is greater than zero?

    Perfect is 100% correct. This will save me a lot of time!

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Ithaca
    Posts
    108

    Talking Re: =COUNTIF(A1;A10.....value is greater than zero?

    lol

    Was wondering why this thread has over 9,700 views...

    Nice bump

  6. #6
    Board Regular
    Join Date
    Sep 2010
    Posts
    97

    Default Re: =COUNTIF(A1;A10.....value is greater than zero?

    I think it has this many page views because the formula does not always work.

  7. #7
    New Member
    Join Date
    Jun 2013
    Posts
    1

    Default Re: =COUNTIF(A1;A10.....value is greater than zero?

    you're a star!! this saves me countless minutes

  8. #8
    New Member
    Join Date
    Apr 2008
    Posts
    9

    Default Re: =COUNTIF(A1;A10.....value is greater than zero?

    strange that this requires the ""...

  9. #9
    New Member
    Join Date
    Oct 2014
    Posts
    4

    Default Re: =COUNTIF(A1;A10.....value is greater than zero?

    Quote Originally Posted by onlyadrafter View Post
    Hello,

    Does this suit your needs?

    =COUNTIF(A1:A10,">0")

    How could i do this if the cells to count if greater than 0 are not in a range. I need to count how many cells are greater than 0 from the flowing cells:
    B15,
    B19,
    B23,
    B27,
    B31,
    B35,
    B39,
    B43

    Any answers in those cells greater than 0 should be shown in cell B47.

    Many thanks

  10. #10
    Board Regular FormR's Avatar
    Join Date
    Aug 2011
    Location
    UK
    Posts
    1,581

    Default Re: =COUNTIF(A1;A10.....value is greater than zero?

    Quote Originally Posted by b19upj View Post
    Any answers in those cells greater than 0 should be shown in cell B47.
    Welcome to the board!

    Try this is cell B47:

    =SUMPRODUCT(--(MOD(ROW(B15:B43)-ROW(B15)+1,4)=1),--(B15:B43>0))
    What on Earth is Recursion?
    Floating Point

    I use XL2010 @ Home & Work and unless otherwise stated will assume you do too.

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com