counting cells that contain a date

  • Thread starter Thread starter jimar
  • Start date Start date
J

jimar

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
 
Hi,

providing there are only dates and text in column B then this should do it.

=SUMPRODUCT((A1:A20="Apple")*(ISNUMBER(B1:B20)))

Mike
 
Thanks Mike. Works great.

Mike H said:
Hi,

providing there are only dates and text in column B then this should do it.

=SUMPRODUCT((A1:A20="Apple")*(ISNUMBER(B1:B20)))

Mike
Click to expand...
 
Back
Top