assuming your column a has a header
then
=COUNTBLANK(E2:INDEX(E:E,COUNTA(A:A)))