+ Reply to Thread
Results 1 to 3 of 3

Count the number of text string Occurence if the Value in another Column is "Adair"

  1. #1
    Registered User
    Join Date
    10-10-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Count the number of text string Occurence if the Value in another Column is "Adair"

    Hi
    I am working a spread sheet for work. This is NOT homework and this is not part of the duties I get paid for. Like the title says. I need to Count the number of text string Occurence if the Value in another Column is "Adair" (as an example) This is what I cam up with and it is not working. Can someone please help?


    =PRODUCT(--(January!L3:L900="Adair"),(COUNTIF(January!G3:G902, "Active / Change")))

    Thank you
    tish

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Count the number of text string Occurence if the Value in another Column is "Adair"

    I think you are missing an = before active/change.
    I would probably go with
    =sumproduct(if(January!L3:L900="Adair",1,0)*if(January!G3:G902="Active/Change",1,0))
    It's an array formula so you need to confirm with ctrl+shift+enter

  3. #3
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Count the number of text string Occurence if the Value in another Column is "Adair"

    Hmmm,

    I'm a bit suspicious about those arrays being of unequal size.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

+ 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. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  2. Count Number of times Column A says "X" where Column B says "Y"
    By Bellio3105 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-10-2012, 06:29 AM
  3. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  4. Replies: 1
    Last Post: 07-16-2010, 02:44 AM
  5. Increment Cell Count If Column Contains "String"
    By Barrelroll in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2010, 11:45 PM

Tags for this Thread

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