+ Reply to Thread
Results 1 to 3 of 3

Dynamic COUNTIF looking for text referenced in cell searching in comma-separated string

  1. #1
    Registered User
    Join Date
    09-26-2019
    Location
    Philadelphia
    MS-Off Ver
    Mac 16.29
    Posts
    2

    Question Dynamic COUNTIF looking for text referenced in cell searching in comma-separated string

    Hey all,

    I we have a series of emails that go out every week to people for educational purposes. I have been asked to provide a weekly report showing how many emails are going out for each topic so we know what is the most popular.

    The report that I recieve is based on the use and kicks out the emails they received for that week in comma sepreated format like this:
    Asymmetric Information; Externalities; Multiple Email Notification; Poverty & Inequality; Public Goods


    I am trying to dynamically count the number of times each topic has gone out on another tab (Week 11). So far I have found that I can do this:

    =COUNTIF(Table1[Week 11],"*Asymmetric Information*")

    However, is there a way to reference the text I am searching for in another cell for the lookup vs having to type it each time?

    I have a list of topics that is quite long in Column A on my summary sheet and I need to keep doing this list every week for historical purposes so it would be much easier to be able to drag the formula down the list.


    Cell A3 contains Asymmetric Information (which I need to cound how many times it appears on the sheet Table1[Week 11]


    Thank you!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,540

    Re: Dynamic COUNTIF looking for text referenced in cell searching in comma-separated strin

    Like this maybe?

    =COUNTIF(Table1[Week 11],"*"&A3&"*")
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    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.

  3. #3
    Registered User
    Join Date
    09-26-2019
    Location
    Philadelphia
    MS-Off Ver
    Mac 16.29
    Posts
    2

    Talking Re: Dynamic COUNTIF looking for text referenced in cell searching in comma-separated strin

    Yes, that worked, thank you so much!

+ 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. Reduce variable string to comma separated string
    By madsfdk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2019, 07:18 AM
  2. [SOLVED] Dynamic COUNTIF function looking for text value in comma-separated string
    By thewhawk in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-27-2017, 06:29 PM
  3. [SOLVED] How to extract words from a text string separated by comma
    By shukla.ankur281190 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-22-2015, 04:16 AM
  4. [SOLVED] Find the Position of String in a comma separated cell
    By Praveenk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-15-2015, 07:27 AM
  5. Replies: 8
    Last Post: 01-16-2015, 12:16 PM
  6. Search cell for multiple text , return comma separated text in separate cell if found
    By dangerdoug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-01-2013, 01:52 PM
  7. Searching a comma delimited string in a cell
    By migpics in forum Excel General
    Replies: 7
    Last Post: 11-26-2007, 05:58 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