Results 1 to 6 of 6

Formula to count adjacent cells containing specific text

Threaded View

  1. #1
    Registered User
    Join Date
    05-16-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    6

    Formula to count adjacent cells containing specific text

    Hia.

    I have a worksheet with 7 columns & 2500 rows. Each cell in that contains a series of words (Required, N/A, Match, etc.).

    For each row I need to count as per the following logic :-
    Does the Row (A1) start with the word "Required" - if so then add 1 to the row count & if not then stop & goto the next row.
    Does the adjacent cell (B1) contain the word "Required" if so add 1 to the row count & if not then stop & goto the next row.
    Does the adjacent cell (C1) contain the word "Required" if so add 1 to the row count & if not then stop & goto the next row.
    Repeat for each of the 7 columns.

    In the simplified example below ......
    Row 1 should return 2
    Row 2 should return 1
    Row 3 should return 2
    Row 4 should return 3
    Row 5 should return 0
    Row 6 should return 0

    Screen Shot 2017-08-17 at 18.01.18.png

    Hope the above makes sense - have been bashing my head on this one for hours now so hoping someone can point me in the right direction.

    Many thanks !!
    Last edited by BuddJ; 08-17-2017 at 01:01 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count of adjacent cells with specific text
    By dancing-shadow in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-12-2016, 01:04 PM
  2. Replies: 4
    Last Post: 02-11-2015, 09:02 AM
  3. Replies: 9
    Last Post: 09-30-2014, 09:10 AM
  4. Replies: 3
    Last Post: 12-28-2013, 07:53 PM
  5. [SOLVED] Formula needed to only count total cells entered and not count adjacent text entered cells
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-07-2013, 06:22 PM
  6. Replies: 2
    Last Post: 07-31-2012, 01:11 PM
  7. Excel formula to count cells with specific text
    By timtrace in forum Excel General
    Replies: 3
    Last Post: 04-06-2011, 12:32 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