+ Reply to Thread
Results 1 to 2 of 2

COUNTIF for specific text from drop down list

  1. #1
    Registered User
    Join Date
    06-30-2020
    Location
    Kuwait
    MS-Off Ver
    MS office
    Posts
    2

    COUNTIF for specific text from drop down list

    Hi,

    I have a sheet with the following

    Column A - Project Number (with Drop down list)
    Column C - Main Activities (with Drop down list)
    Column D - Sub Activites (with Drop down list)

    Is it possible to create a formula to calculate how many cells contain specific text that has been selected from a drop down list (of Column A, C and D) matches to each other

    i have tried =COUNTIFS($J$2:$J$25,"120",$K$2:$K$25,"Capacity Building",$L$2:$L$25,"training")

    But it gives me "0", i want it to count how many times Project 120 in column A was used for Capacity building in Column C and to the sub activity in Column D

    Note: when the formula is used on normal text which mean not based on drop down list it work, but the moment i use it on the drop down list columns it doesn't work

  2. #2
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,146
    Hello Raouf123,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Replies: 6
    Last Post: 02-16-2017, 05:08 PM
  2. Converting text in a drop down list to a specific # in another cell
    By Shawn4789 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-24-2016, 04:14 PM
  3. [SOLVED] Place text in a specific cell based on two separate drop down list entries
    By fazthfc in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-24-2015, 03:34 PM
  4. [SOLVED] CountIf cell copntains specific text generated dropdown list
    By michael.reynolds1775 in forum Excel General
    Replies: 2
    Last Post: 11-19-2014, 05:27 PM
  5. Replies: 2
    Last Post: 08-02-2013, 08:04 AM
  6. VBA to select specific Text in Drop Down List
    By woolen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2012, 09:37 AM
  7. VBA to select specific Text in Drop Down List
    By woolen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2012, 05:20 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