counting unique values based on a condition with autofiltering

[sammybr]

Hi all,

Like all, apologies if this may have been answered already...

I have a column that contains unique values and I am able to count the total amount of unique entries that updates when an autofilter is used. The formula I have used is:

=SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(M32,ROW(M32:M6294)-ROW(M32),,1)),
IF(M32:M6294<>"",MATCH("~"&M32:M6294,M32:M6294&"",0))),ROW(M32:M6294)-ROW(M32)+1),1))

My question is, how can I further restrict this to only provide unique values if the condition in say cell I7 appears in column "S"?

I am using excel 2010 if this helps?

Thanks heaps

Sam

 

[sammybr]

Sorry... One more thing I should have mentioned is that I enter this formula as an array (CNTRL + SHIFT + ENTER).