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