Determing n=? using COUNT

C

CatPEG

I want to determine the no. of entries/column and things were going fine for
the first 3 columns using COUNT. Then it went into a circular reference
which I figured out how to click on to (I think) eliminate; thereafter I get
a value of "0" entries for that column, when it should read "29"

Any idea what's going on? All I want is a simple total at the bottom of
each column telling me how many observations were made in that year...
 
T

Tyro

It's hard to respond to your question since you did not provide your formula
and an example such as: A1:A100 contain data. In row 101 is the formula
=COUNT(A1:A100). Please provide us with an example of the data in A1:A5 and
your formula in A6.

tyro
 
R

Roger Govier

Hi

If you are using COUNT on a whole column, with the formula within the range,
then you will get a circular reference.

Why not insert a new row 1 (above your header or data) and use
=COUNT(A2:A65536)
(if you really need to use the whole of the column - otherwise limit it to a
range that exceeds your likely usage)
 
Top