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...

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

"CatPEG" wrote in message
...
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...

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)

--

Regards
Roger Govier

"CatPEG" wrote in message
...
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...