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