counting cells that contain a date
 

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

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

counting cells that contain a date
 

Thanks Mike. Works great.

"Mike H" wrote:

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

counting cells that contain a date
 

Glad I could help


"jimar" wrote:

Thanks Mike. Works great.

"Mike H" wrote:

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