+ Reply to Thread
Results 1 to 3 of 3

How to count number values in LEFT & RIGHT in a cell range with criteria

  1. #1
    Registered User
    Join Date
    04-14-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    97

    How to count number values in LEFT & RIGHT in a cell range with criteria

    Hello Experts,

    I am task to create a statistics from a blood pressure of individuals and I have this value in my Column A as below

    4-Aug-20
    163/82
    169/83
    173/93
    152/89
    143/82
    135/72
    170/79
    170/82
    163/89
    157/82
    140/77
    109/67

    I want to count
    < = 120/80
    >120/80 & <= 135/85
    > 135/85

    I tried only by doing taking the left values =VALUE(LEFT(A2:A13,3)) but that's not what I want

    Is there a way to count values in left & right with the criteria as above?

    I really appreciate any kind of help.

    Thanks in advance
    Rev12

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,412

    Re: How to count number values in LEFT & RIGHT in a cell range with criteria

    1st high:
    Please Login or Register  to view this content.
    second high:
    Please Login or Register  to view this content.
    third:
    Please Login or Register  to view this content.
    the last three remain are mixing of upper index/lower index. (i.e, 163/82)
    Quang PT

  3. #3
    Registered User
    Join Date
    04-14-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: How to count number values in LEFT & RIGHT in a cell range with criteria

    Thank you bebo021999 at least I can work on my index a bit, thanks again.

+ 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. How to extract certain number LEFT from the criteria if it's found in the cell
    By bartalosmoni in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2019, 01:10 PM
  2. Replies: 4
    Last Post: 11-01-2016, 03:28 PM
  3. Replies: 2
    Last Post: 11-22-2013, 01:07 PM
  4. [SOLVED] Count values in a range if adjacent cell meets a particular criteria
    By DougC in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-22-2013, 03:12 PM
  5. [SOLVED] Would like to count cell values based on date criteria in a different range
    By sdavison in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-23-2013, 12:45 AM
  6. Count multiple values in cell with range criteria
    By leanne13 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-06-2009, 02:26 PM
  7. Replies: 0
    Last Post: 08-25-2005, 05:52 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1