using Countif Function: Column number stored in a variable

Hello,

Would require vba code for the given example please..

need to count number of "Pass" for a particular column and the column number is stored in a variable ( say Variable Resultval= 3, countif should calculate number of "Pass" in column C )

tried following code but could not get expected result

Please Login or Register  to view this content.

Thanks.

Thanks Marvin... it is resolved ( but still curious to understand what is wrong with the 'Evaluate' i have used...will try and figure out later....thanks for your quick help)