"S Davis" wrote...
I need to do a count on a list (from a database) that grows and
shrinks. It needs to exclude the last 200 entries depending on
where the end of the list is.
....
Possible?

Yes.

My only idea (failure by the way) was something like

A1 = counta(B1:B1000) = result is 1000
A2 = average(B1:(address(A1,2)-200))
....

If your COUNTA formula in A1 is reliable (there are never any blank
cells in col B), you could try the following in A2.

=AVERAGE(B1:INDEX(B:B,A1-200))