counting cells that contain a date
Hi,
providing there are only dates and text in column B then this should do it.
=SUMPRODUCT((A1:A20="Apple")*(ISNUMBER(B1:B20)))
Mike
"jimar" wrote:
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
|