ExcelBanter - COUNT Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - COUNT Function (https://www.excelbanter.com/excel-discussion-misc-queries/208705-count-function.html)

SiH23

COUNT Function

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

COUNT Function

=COUNTA(B:B)-COUNTA(B1)
--
Gary''s Student - gsnu200811

SteW

COUNT Function

=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?

ShaneDevenshire

COUNT Function

Hi,

Two formulas
=COUNTA(B2:B65536)

or

=COUNTIF(B2:B65536,"<")

If these help click the Yes button.
--
Thanks,
Shane Devenshire

"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?

All times are GMT +1. The time now is 04:38 AM.