+ Reply to Thread
Results 1 to 5 of 5

How to select and count cells with value higher than 0.00

  1. 08-28-2015, 05:44 AM #1
    Schalk
    Schalk is offline
    Forum Contributor
    Join Date
    11-15-2011
    Location
    South Africa
    MS-Off Ver
    Office 365
    Posts
    101

    How to select and count cells with value higher than 0.00

    Cells A1 and A2 must count all the cells in the same row that have values higher than 0.00
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-28-2015, 05:47 AM #2
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: How to select and count cells with value higher than 0.00

    Hi.

    In A1:

    =COUNTIF(B1:XFD1,">0")

    Copy down as required.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  3. 08-28-2015, 05:48 AM #3
    cbatrody
    cbatrody is offline
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: How to select and count cells with value higher than 0.00

    Hi,

    Try the following in A1:

    =COUNTIF(B1:M1,">"&0)
    Reply With QuoteRegister To Reply
  4. 08-28-2015, 05:49 AM #4
    Schalk
    Schalk is offline
    Forum Contributor
    Join Date
    11-15-2011
    Location
    South Africa
    MS-Off Ver
    Office 365
    Posts
    101

    Re: How to select and count cells with value higher than 0.00

    Would you mind explaining the formula, it would be nice to understand what I'm doing. What is the "XFD1"?
    Reply With QuoteRegister To Reply
  5. 08-28-2015, 06:35 AM #5
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: How to select and count cells with value higher than 0.00

    XFD1 is the reference for the last cell in row 1.

    Regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How do I make Excel count values higher than 2 as 2
    By Zack96 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-02-2015, 02:03 AM
  2. [SOLVED] Select a range of cells based on row count
    By bdrilling33 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2014, 06:07 PM
  3. Count number of times one value is higher than another IF criteria is true
    By LasseKaa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-17-2013, 11:28 AM
  4. [SOLVED] Does a 'count if higher than other cell' function exist?
    By Apparas in forum Excel General
    Replies: 4
    Last Post: 10-08-2012, 11:06 AM
  5. Identifying 3 cells higher & lower vales & substract higher to lower values
    By friendlykashish in forum Excel General
    Replies: 2
    Last Post: 05-31-2010, 03:23 PM
  6. [SOLVED] need to select closest match using vlookup if it higher or lower
    By vlookup help pls in forum Excel General
    Replies: 1
    Last Post: 03-01-2006, 03:35 PM
  7. [SOLVED] Is there a way to count higher than 511 in binary in excel?
    By havocdragon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2005, 01:05 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1