COUNT Function

  • Thread starter Thread starter SiH23
  • Start date Start date
S

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?
 
Hi,

Two formulas
=COUNTA(B2:B65536)

or

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

If these help click the Yes button.
 
Back
Top