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
Bookmarks