Hi,

following the discussion from
http://www.excelforum.com/excel-form...ml#post3434799

i have the following question;

I've tried to use the formula introduced by Daddylonglegs but it's not working for me. my case is slightly different. the formula i need, based on Daddy's formula is below. it doesn't work but should be something like that i suppose.

=SUM(IF(FREQUENCY(IF($H$8:$H$2381>AQ2383,IF($H$8:$H$2381<AQ2384,$AD$8:$AD$2381="paid", MATCH($L$7:$L$2381,$L$7:$L$2381,0))),ROW($L$7:$L$2381)-ROW($L$7)+1),1))


so basically,
1-I verify that in column H, the date is bigger than AQ2383
2-same thing as #1, verifying in column H that the date is smaller than AQ2384
3-then i want from column AD, only "paid" text. (and what do i need to do if i want "paid" and "cancelled"??)
4-this is where i get stuck, i want the count of unique values in column L.

i've also tried the formula below with sumproduct and it gives me correct value, but it counts all the duplicates. but with this sumproduct, I don't know how i can have it count the unique values in column L..
=SUMPRODUCT(($H$8:$H$2381>=D2)*($H$8:$H$2381<=D3)*($AD$8:$AD$2381={"paid","cancelled"}))

thanks a lot in advance for your support