Prev: Vlookup help pls??
Next: Purchasing Excel for a PC to share files with Mac version 2008?
From: Sam.D on 29 Jan 2010 11:04
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
From: מיכאל (מיקי) אבידן on 29 Jan 2010 11:27
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
 | 
Pages: 1
Prev: Vlookup help pls??
Next: Purchasing Excel for a PC to share files with Mac version 2008?