Hello,

I'm trying to use this formula but want it to count the number of blanks only within the data, i.e. not to count the number of blanks after the last row of data:

=COUNTBLANK(Progress!$G:$G)

This is counting all the blanks (65363)

I want to use G:G as the range because I want it to update automatically.

Do you know of a way I can do this?

Thanks
Harry