+ Reply to Thread
Results 1 to 5 of 5

Quick Query regarding basic formula regarding counting from a row with drop down input

  1. #1
    Registered User
    Join Date
    08-28-2014
    Location
    Glasgow
    MS-Off Ver
    2007
    Posts
    11

    Quick Query regarding basic formula regarding counting from a row with drop down input

    Just trying to count pass and fail in a row - I've added drop down 'Pass' 'Fail' list to stop input errors
    =COUNTIF(C5:AZ5,"Pass")
    I was using this formula - but since I added the drop downs it doesn't work?
    Prob quite simple to solve but I'm new to this game?
    Cheers

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Quick Query regarding basic formula regarding counting from a row with drop down input

    Hi,

    an attempt: I'm cheking in there could be ' or "" in data validation list.


    =COUNTIF(C5:AZ5,"*Pass*")

    Cheers
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    08-28-2014
    Location
    Glasgow
    MS-Off Ver
    2007
    Posts
    11

    Re: Quick Query regarding basic formula regarding counting from a row with drop down input

    Many thanks!

  4. #4
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Quick Query regarding basic formula regarding counting from a row with drop down input

    Hi,

    you're welcome: thanks for giving kind feedback.

    In your data validation "allowed" list you can simply write

    Pass,Fail

    instead of

    'Pass','Fail'

    in order to avoid asteriks (*) in COUNTIF.

    Regards from Firenze

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Quick Query regarding basic formula regarding counting from a row with drop down input

    If you only have Pass or Fail in tyour dropdown, and this works for you...
    =COUNTIF(C5:AZ5,"*Pass*")

    This is kinda telling me that you may have leading or trailing spaces (or something else) in your validation list. Fix that 1st, before looking for work-arounds
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Conditional formula query (drop down lists)
    By Grim715 in forum Excel General
    Replies: 1
    Last Post: 07-19-2011, 07:58 AM
  2. Basic counting formula required
    By lukevl in forum Excel General
    Replies: 6
    Last Post: 05-25-2009, 09:02 AM
  3. Quick Query
    By captainboosh in forum Excel General
    Replies: 1
    Last Post: 09-11-2007, 05:27 PM
  4. Basic Excel formula query
    By danviggers in forum Excel General
    Replies: 7
    Last Post: 11-22-2006, 10:27 AM
  5. Quick question about the # in visual basic
    By bjornast in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2005, 08:29 AM

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