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
Bookmarks