Formula Range to reference cell value

[Simon.xlsx]

Hi All,

I am trying to complete a countif function

I have a set of named ranges as the months of the year

January = A2:GT32
February = A33:GT61
etc......

I have a drop down on another sheet (A1) that has the named ranges names, I need my countif formula to read "=countif(A1,A3)", where "January" is selected in cell A1

However i need it to return "A1" as the named range and not look at it as a single cell

the end result been the user can pick a month and the formula will return information from that named range

Im not sure if this is straight forward

Thanks in advance for any replies

[Special-K]

In another cell cant you determine what range it should be based on the month selected?
something like

=COUNTIF(IF(A1="Jan",A2:A32,IF(A1="Feb",A33:A61..etc,A3)
or
=COUNTIF(INDIRECT(LOOKUP(A1,{"Jan","Feb","Mar"...},{"A2:A32","A33:A61","A62:A90"...})),A3)

[Simon.xlsx]

thanks for your quick reply,

that works perfect, should have figured it out myself

Monday Blues

Thanks, Rep Added