+ Reply to Thread
Results 1 to 2 of 2

count cells that have a higher value than the cell above it in a row

  1. #1
    Registered User
    Join Date
    08-31-2016
    Location
    India
    MS-Off Ver
    windows enterprise 7
    Posts
    1

    Post count cells that have a higher value than the cell above it in a row

    Hi All
    I am looking for a excel function, which would help me to count the number of cells in a given row which is higher the cells above it.
    For e.g. I am comparing the cells in row #1 and #2 from Column A to Column L
    I want to count the number of cells in #2, between 2A and 2L, that are having a value higher than its corresponding cells in #1 between 1A and 1L.
    What function would I use.

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: count cells that have a higher value than the cell above it in a row

    Perhaps

    Try

    M2=SUMPRODUCT(--(A1:L1>A2:L2))
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count the number of cells' values higher than X%
    By LesliePrabakar in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-27-2016, 09:03 AM
  2. [SOLVED] Reformulate IF statement to count when higher than 0
    By Exequiel3k in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-11-2016, 03:05 PM
  3. [SOLVED] How to select and count cells with value higher than 0.00
    By Schalk in forum Excel General
    Replies: 4
    Last Post: 08-28-2015, 06:35 AM
  4. Replies: 1
    Last Post: 01-06-2014, 09:39 PM
  5. Replies: 2
    Last Post: 09-23-2013, 01:09 AM
  6. [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
  7. Replies: 2
    Last Post: 05-31-2010, 03:23 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1