+ 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
    17

    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,326

    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
    17

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

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

    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