reference column from another cell

[tmmellor1981]

I've scoured the forums and google put perhaps not searching for the correct question. I have the following formula:

=COUNTIFS(Account_Opened!$B:$B,">="&$BE$91,Account_Opened!$B:$B,"<"&$BI$91,Account_Opened!$P:$P,$BC94)

I have a box that populates me a list of ranges and would like the $P:$P part of the formula to change to whatever is in that cell e.g one of the following
$P:$P
$Q:$Q
$R:$R

or if there is a way of using a column number somehow.

many thanks and i'm sure as usual a guru will find this one easy

 

[gaz_chops]

Try
A1 is the cell that contains $P:$P etc

=COUNTIFS(Account_Opened!$B:$B,">="&$BE$91,Account_Opened!$B:$B,"<"&$BI$91,indirect("Account_Opened!"&A1),$BC94)

Edit : Missed the ) after A1

 

[tmmellor1981]

many thanks knew there was a way somehow

 

[gaz_chops]

You're welcome.