frequency counts excluding repeated values

Hi there,

I have the following sheet:


type room no of participant month day duration
meeting 6 1000 5 2 19
meeting 6 1000 5 2 15
conference 6 250 5 4 9
conference 6 1000 5 4 13
conference 4 300 5 2 5
seminar 3 400 6 1 8
seminar 2 300 6 1 10
seminar 4 1000 6 3 13


I want to count the "duration" that greater than or equal to 10 (for "no. of participants" =1000 and "month"=5), but NOT duplicate counts for duration >=10 that occured on the same day.

So in the above example, I should get 2 cases instead of 3 ( on day 2 & 4), as the "day"=2 which exceeds "duration" 10 is only counted ONCE even though there are two occurences.

How can I do that in Excel? Thanks a lot for any reply.