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