Hello all,

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.

I'll be doing average, stdev, counta, and more functions with this
list so it is not as simple as just counting the list and subtracting
200. Essentially i need to tell microsoft where the end of the list
is, then only do calc's on everything but the previous 200 cells.

Possible?

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

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

.... but it appears you can not have cell references when calculating
on a range.

Thanks for any help :)
-SD