I want to use the COUNTBLANK formula to count the number of empty cells in a
column up until the end of the list of records. I don't know the definite
number of records so i need to dynamically assign the number that the cell
number that the formla should count up to.

ie
COUNT BLANK(D2:Dxxx) where Dxxx is equal to the following function

=MATCH(2,1/(1-ISBLANK(Evaluations_Query!A1:A3417)))+1

how do i generically insert formular into functions or is this even possible?