Results 1 to 2 of 2

Thread: Count Of Numbers Greater Than Zero In Excel Sheet Using Formula

  1. #1
    Junior Member
    Join Date
    Nov 2012
    Posts
    1
    Rep Power
    0

    Count Of Numbers Greater Than Zero In Excel Sheet Using Formula

    I have a column with values and empty cells. I have made a link to another sheet and the empty cells appear as zero then. So the column looks like this:

    0
    3030
    5798
    3009
    3730
    2778
    4987
    7477
    0
    0
    16960
    0
    25349
    0
    0
    0
    0

    Now, I would like to no how many values if have got in the whole column (so not the zero's). Is there a formula to do so? I was thinking about the IF>0 stuff..

    Many thanks

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi MichielV,

    Welcome to ExcelFox !!

    To count the numbers greater than 0, try

    =COUNTIF(A2:A100,">0")

    adjust the range.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Count Colored Cells Using Excel Formula
    By mahmoud-lee in forum Excel Help
    Replies: 4
    Last Post: 06-15-2013, 11:37 AM
  2. Replies: 1
    Last Post: 05-19-2013, 02:37 PM
  3. Replies: 2
    Last Post: 12-26-2012, 08:31 AM
  4. Replies: 2
    Last Post: 12-19-2012, 11:52 PM
  5. Count consecutive value in a range using formula
    By LalitPandey87 in forum Excel Help
    Replies: 6
    Last Post: 11-12-2012, 05:23 PM

Posting Permissions

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