COUNT Function

[SiH23]

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?

 

[Gary''s Student]

=COUNTA(B:B)-COUNTA(B1)

 

[stew]

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

 

[ShaneDevenshire]

Hi,

Two formulas
=COUNTA(B2:B65536)

or

=COUNTIF(B2:B65536,"<>")

If these help click the Yes button.