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