+ Reply to Thread
Results 1 to 4 of 4

COUNTIF referencing different named ranges in dropdown list

  1. #1
    Registered User
    Join Date
    09-16-2006
    Posts
    2

    COUNTIF referencing different named ranges in dropdown list

    Hi, I'm trying to get the COUNTIF function to reference one of a list of named ranges selected by the user from a dropdown list. Is this possible? For example:

    =(COUNTIF(Wins06,"1")) where Wins06 can be Wins05 or Wins04, etc.

    Let's say the cell ref of the dropdown list containing the different range names is A6, the following doesn’t work:

    =(COUNTIF(A6,"1"))

    In other words, I'd like the user to choose what period he wants to analyse (from the dropdown list of ranges), and then let the COUNTIF function tell him how many wins he scored in that time range.

    Thanks

  2. #2
    Forum Expert
    Join Date
    09-09-2005
    Location
    England
    MS-Off Ver
    2007
    Posts
    1,500
    =COUNTIF(indirect(A6),"1")

    regards

    Dav

  3. #3
    Registered User
    Join Date
    09-16-2006
    Posts
    2
    Thanks, Dav, that did the trick

  4. #4
    Registered User
    Join Date
    05-24-2011
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: COUNTIF referencing different named ranges in dropdown list

    Dav - thanks. I used your answer to this thread to help me out with another problem - which is now solved. Appreciated. Alan

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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