=COUNT

[Rosa]

In a cell I have =COUNT(B:B)
To count the number of times data occurs in column B,
obviously. But I get zero. There is four lines of header
on it, is that the problem?

 

[Frank Kabel]

Hi
try
=COUNTA(B:B)

if you don't want the 4 heading rows counted try
=COUNTA(B5:B1000)

 

[Patty]

=Count...only works to count numbers. If you are trying
to count field with both numeric and alpha characters
choose =CountA.