task 1

sir there are different sized data present in the application file , like in 1st row there is 5000 DATA present there but in cell W we have 307514 rows present there and many more . this is very confusing for me to how to calculate null values for column 1 should i write formulae countblank(A1:A5000) or countblank(A1:A307514) thanks