Using Index and indirect to count number of 1's in a column of interest.

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

I have previously been using the equations such as :

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

Thanks again

Alan

Solved thanks alot