I am not sure there is a way to do this. But, it would be nice if I could have say a column listing defined range names. The hard part: I would like to be able to reference the column of cells containing those range names in COUNTIFS formulae --obviously for ranges, such that the formula recognizes the data in the referenced cell as a range name rather than text.

I seem to need a symbol that screams out to Excel that the following is a range name, just as ampersand does for text....