Hi,

I am trying to do the following with the below data:

For a specific date, I need to calculate the number of transactions. A
transaction ID can appear more than once if there are several items
sold during this transaction.
for the 05/12/2006 the answer should be 3 (transaction ID 4, 6  & 8)
and the 5 if date was the 6th and 4 if the date was the 7th?

I have this

=SUM(1*(FREQUENCY(C2:C21,C2:C21)>0))

to caculate the unique transactions (12)and

=COUNTIF(D2:D21,"05/12/2006")

to tell me there are 8 rows for the 5th but I struggle to get the
intersection of the 2.

Price Paid    Item Ref    Transaction ID    Date
5    PPC003    4    05/12/2006
0    PPC001    4    05/12/2006
100    PPC004    6    05/12/2006
200    PPC004    6    05/12/2006
100    TEL102    8    05/12/2006
5    PPC003    8    05/12/2006
0    PPC001    8    05/12/2006
1000    PPC004    8    05/12/2006
55    PPC004    13    06/12/2006
99.99    PPC004    15    06/12/2006
30    PPC004    16    06/12/2006
40    PPC004    17    06/12/2006
20.99    PPC004    18    06/12/2006
50    PPC004    19    07/12/2006
100    PPC004    21    07/12/2006
100    PPC004    21    07/12/2006
120    PPC004    23    07/12/2006
150    PPC004    23    07/12/2006
250    PPC004    23    07/12/2006
200    PPC004    26    07/12/2006