SUMPRODUCT help with filter

  • Thread starter Thread starter Sam.D
  • Start date Start date
S

Sam.D

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
 
SUBTOTAL with the function_num = 3 should count.
After applying the filter - Try:
=SUBTOTAL(3, F2:F1475)
Micky
 
Back
Top