Results 1 to 16 of 16

Counting only if adjacent rows match with multiple criterias

Threaded View

  1. #1
    Registered User
    Join Date
    02-01-2016
    Location
    Milwaukee, WI
    MS-Off Ver
    2013
    Posts
    28

    Counting only if adjacent rows match with multiple criterias

    I am racking my brain trying to figure out how to do this formula, and have scoured the internet forums without success. I am trying to create a formula that counts how many times adjacent rows in column b match with the criteria that a specific text in column E matches and with data in column J that is greater than 360 and less than 480. Thank you for taking the time in advance.

    ----[B]----------- [E]--------- [J]
    |11111111|------|Sue|-------|384|
    |11111111|------|Sue|-------|384|
    |12121212|------|Emily|-----|240|
    |12312312|------|Joe|--------|820|
    |15643657|------|John|------|322|
    |13131313|------|John|------|420|
    |13131313|------|John|------|420|
    |25367457|------|Eve|-------|384|
    |84453234|------|John|------|362|
    |84453234|------|John|------|362|
    |84453234|------|John|------|362|
    |84453233|------|John|------|382|
    |11111111|------|Sue|-------|222|
    |11111111|------|Sue|-------|222|
    |12312312|------|Joe|--------|361|

    If searching for John it should return 2
    If searching for Sue it should return 1
    If searching for Joe it should return 0
    Last edited by jparve3283; 03-22-2016 at 09:17 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Counting with a lot of criterias across multiple sheets
    By k.m. in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-29-2015, 03:39 PM
  2. Counting with multiple criterias across multiple sheets
    By k.m. in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-11-2013, 03:40 PM
  3. Replies: 0
    Last Post: 05-05-2013, 05:47 AM
  4. [SOLVED] INDEX & MATCH w multiple criterias?
    By Eemmai in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-24-2012, 05:20 AM
  5. counting adjacent cells that match a criteria
    By chrisvacek in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-11-2012, 11:44 AM
  6. Singel out rows that match multiple criterias
    By Ewox in forum Excel General
    Replies: 2
    Last Post: 11-30-2010, 10:39 AM
  7. help please : counting iterations based on multiple criterias
    By ccoindy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-11-2007, 11:40 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