Hi,

I have found out how to determine the number of items in a filtered range by
using the formula
=SUBTOTAL(2,A5:A3000). This works well and tells me the population "n" of
the data class being analysed.

I now need to find the total number of occurrences within the filtered set.

E.g. for finding how many times 5 appears in the filtered range

5
7
5
8
3
= 2 (i.e. 5 appears twice)

All attempts have yielded the count of occurrences of the unfiltered data or
a formula error.

Is it possible to achieve my objective? Any help greatfully appreciated,

regards

Jeff