Use cell locations generated from ADDRESS function in EXCEL

I have been able to generate a range using the ADDRESS function in EXCEL, but cannot find a way to use this range to be used in a COUNTIF formula.

How can I plug in the range received by the ADDRESS function into an array statement?

Thanks