SUBTOTAL with the function_num = 3 should count.
After applying the filter - Try:
=SUBTOTAL(3, F2:F1475)
Micky


"Sam.D" wrote:

I'm currently using the formula

=SUMPRODUCT((F2:I1475=1)*(F2:I1475<=9999))

This gives me the number in the full range but I need this to update when I
put differnet filters on.

I've tried different things with SUBTOTAL but can't get it to work

Any help is greatly appreciated

Sam.D