counting cells that contain a 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
 
M

Mike H

Hi,

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

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

Mike
 
J

jimar

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum if column is equal to 2 options 3
Macro to add numbers in a text string 5
sumif where cells contain Number & Text 8
Min-Max question 6
Counting Subtotal 4
count number of duplicates between 2 columns 8
Counting Unique Pairs of Cells 6
Counting Entries between two dates 3

Top