counting blank cells in every growing table

[Afro_Cookie]

I want to count the number of blank cells in A:A but only relating to my table size. Is there a way to only have the cells in my current table be counted?
Formula's I've tried so far with no luck:

=countblank(A:A)
=countif(A:A,"")

Also, I know it's not VBA code, but wanted to show it nicely. VBA is an option if that is the best method.

 

[Fluff]

Why not just limit the formula to the size of the table?

 

[Afro_Cookie]

Why not just limit the formula to the size of the table?

The table is currently from A9:A250 but not all the values in A are filled in. We add to this table daily and I don't want to have to change the references each day.

 

[Fluff]

Is your "table" a proper table, or just a range of cells?
If it's just a range, then convert it to a proper table and you can use something like
=COUNTBLANK(Table1[Name])

 

[Afro_Cookie]

It was a table already but I did not think of calling the table as a whole, thanks Fluff.

Once again, you've made my bacon.

 

[Fluff]

You're welcome & thanks for the feedback

 

[sandy666]

just for fun with Power Query...
another approach

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Result = Table.SelectColumns(Table.AddColumn(Table.Transpose(Source), "CountBlank", each List.Count(List.Select(Record.FieldValues(_), each _ = null))),{"CountBlank"})
in
    Result

eg.

Count		CountBlank
a		4
x
d
z
dr

blue table contain blanks and empty strings but only real blanks will be counted