Unable to utilize already used formula for Data validation

I am working with the Access Analytic template for multi level dependant data validation drop downs.

COUNTA counting blanks in one case, not in another

I have two workbooks that use COUNTA, to count if there is a value throughout the row