=COUNTIF(B2:B65536,"=0")

"SiH23" wrote:

I need to calculate the number of cells containing data within the range
B2:B65536. Will the Count function do this? There will be blank cells
present. How do you get a function to reculate itself once additional data
has been added?