Conditional CountIf (need to use Autofilters)

[FAHall]

I want to utilize my COUNTIF function with other conditional criteria through autofilter.

Here is my function:

=COUNT(IF(FREQUENCY(MATCH(C7:C439,C7:C439,0),MATCH(C7:C439,C7:C439,0))>0,1))


This is used to count unique employee #s in column C from row 7-439, and it works for getting me a total regardless of filters, but I need to get filtered totals as well.

I believe there is a way to do this using a SUMPRODUCT function, but I can't seem to figure it out.

Can someone please point me in the right direction for making the above function compatible with filters?


Thanks,
-Alex

[NBVC]

Try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER

[FAHall]

That gets me #N/A

I should have specified that the values in the column are number and letters (e.g. H57).

I tried converting the SUM to COUNT, but that just got me "0", which I guess is better than #N/A, but still not what I want.

=)

Thanks,
-Alex

[NBVC]

One of my arrays is a little to big.. fat fingers...

Try:

Please Login or Register  to view this content.

[FAHall]

Worked like a charm!

Thank you very much for the help. It is much appreciated.

Thanks,
-Alex