HELP! Counting number of items based on criteria and date

Hello Everyone,

I'm a newbie. I'm hoping that somebody can help me enter a formula on the attached workbook to count the number of Unique Categories of the Process which occurred on or after the specified date. Duplicate items should not be counted.

Thanks in Advanced

Originally Posted by menem

I was try to write a formula to refer all column , but it's take too long for calculation.
So, I have to limited the calcuation range by help of INDIRECT function.

G4
=LOOKUP(2,1/(A:A<>0),ROW(A:A))
This formula is use for find the last row of column A.

F5
=SUM(IFERROR(1/COUNTIFS(INDIRECT("A1:A"&G4),">="&$F$3,INDIRECT("B1:B"&G4),$F$4,INDIRECT("C1:C"&G4),INDIRECT("C1:C"&G4)),0))
And press Ctrl-Shift-Enter for making it to ARRAY Formula.


Regards.

Wowwww! This is working!
You are a Master!
Thanks for helping! Appreciate it!

Originally Posted by Bo_Ry

Please try at F5

=COUNT(1/FREQUENCY(IF((A2:A14>F3)*(B2:B14=F4),MATCH(C2:C14,C2:C14,)),ROW(C1:C14)))

Press Ctrl+Shift+Enter

Also working but i'm having an incorrect count when I'm changing the dates. Thanks for helping! I appreciate it!

Originally Posted by Bo_Ry

How about add equal sign

=COUNT(1/FREQUENCY(IF((A2:A14>=F3)*(B2:B14=F4),MATCH(C2:C14,C2:C14,)),ROW(C1:C14)))

Press Ctrl+Shift+Enter

This is now working PERFECTLY!!! Awesome exactly what I needed. Super Thanks!!!