Hello all thanks for taking the time to look at my problem.

I have previously been using the equations such as :

=COUNTIF($AHW$18:INDEX($AHW:$AHW,$B$12),"=1")
Where AWH is the column of interest and $B$12 returns the last row of my workbook.

I want to be able to use an indirect in this in order to specify which column to count by inputting a column reference in a cell.

I attempted the equation to use indirect but it returns #REF. Here was my attempt, any suggestions would be appreciated.

=COUNTIF((INDIRECT($AHW$12&ROW(AFY18))):INDEX((INDIRECT($AHW$12):INDIRECT($AHW$12)),$B$12),"=1")
Thanks again

Alan