Q: Are the results of the below identical ?

=ROWS(Name)
=ROWS(Data)
=ROWS(YesNo)

A: No - you have blanks interspersed in the YesNo range (COUNTA generates different value for this range than the others)

A: Yes - do you have underlying #N/A values in YesNo range ?

ie: =COUNTIF(YesNo,"#N/A") returns something other than 0