Quote Originally Posted by popipipo View Post
.....8-4-2014 has a result of 3.....
Assuming the formula is correct then the date isn't part of the criteria - the formula counts the number of different dates (in column A) where the criteria in columns B, C and D are satisfied