+ Reply to Thread
Results 1 to 5 of 5

Counting Text in Different Columns For Single Result

  1. #1
    Registered User
    Join Date
    11-16-2015
    Location
    Rugby England
    MS-Off Ver
    2016
    Posts
    10

    Counting Text in Different Columns For Single Result

    Hello all.

    can someone help me with a countif formula. I know how to use countif to look for text in a column but what i want to count text in a column and in another column at the same time.

    For example, in the attached sheet you will see Column N has Mr Shafi and column F shows done/not done. can i use a single formula count the done and not not against mr Shafi or is it 2 formulas?
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,323

    Re: Counting Text in Different Columns For Single Result

    Something like this ? =SUMPRODUCT(--(N1:N3=N1),--(ISNUMBER(SEARCH("*Done",F1:F3))))
    you can also use the COUNTIFS function, syntax is a bit easier, but the function is not as versatile

  3. #3
    Registered User
    Join Date
    11-16-2015
    Location
    Rugby England
    MS-Off Ver
    2016
    Posts
    10

    Re: Counting Text in Different Columns For Single Result

    Hi and thanks arthurbr.

    the result is 3 as it see the text "Done" in "Not Done" where it should be 2

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Office 365 (Win 10 - Work) & Office 365 Subscription Insider (Win 10 - Home)
    Posts
    39,454

    Re: Counting Text in Different Columns For Single Result

    Is this what you want?

    =COUNTIFS($N$1:$N$3,"Mr Shafi",$F$1:$F$3,"Done")
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  5. #5
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,323

    Re: Counting Text in Different Columns For Single Result

    count the done and not not against mr Shafi
    I understand you stated to count "Done" AND "not done", so why is the formula I Proposed not correct.

+ 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. Formula for counting unique text values in a single column
    By radar1066 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-08-2019, 10:33 AM
  2. Replies: 2
    Last Post: 06-03-2017, 05:01 PM
  3. [SOLVED] Text to columns, transpose data & final result
    By sam1105 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-19-2015, 03:36 AM
  4. Counting text in two columns
    By Roan242 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-15-2015, 04:44 AM
  5. [SOLVED] Need help counting single integers within a text string
    By ksrimmer in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-14-2014, 05:21 AM
  6. [SOLVED] VBA Comparing Single List to Many Lists & Generating A Text as Result
    By kidengineer in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-11-2013, 02:49 AM
  7. Replies: 2
    Last Post: 05-03-2012, 01:18 PM

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