In column A I have a list of fruit ie apples and oranges and in column B I
have a list of dates ie 11/8/08, 12/8/08 etc but Col B also contains text
entries such as "sold out" and "not required". Can anyone please give me a
formula that will count the number of times Apple appears in colum A only
when there is a date in column B. Thanks