COUNTIF occurrences between two dates

[bgrice]

Hello, everyone. This is my first post so apologies if I am breaking etiquette - I mean not to and please point out if I am. I am hoping someone can help with the following:

I need a formula for the table below that will count the number of times a specified fruit is mentioned in a particular month. I have tried COUNTIF and COUNTIFS but with no luck and I have run out of ideas. So, for example, if I want it to calculate how many times 'apples' appears in the month of May, which is twice, I have been trying the following formula. Grateful for your help. Thanks, Benno.

=COUNTIFS(A:A,">=01/05/2017",A:A,"<=31/05/2017,B:B, "*apples*")

Date	Fruit
01/05/17	apples, oranges
06/05/17	apples, pears
20/06/17	pears, bananas
08/08/17	oranges, apples
11/08/17	bananas, oranges
15/10/17	grapes, apples
31/11/17	pears, grapes
20/12/17	bananas, oranges
03/01/18	bananas, pears
11/01/18	pears, apples

<tbody>
</tbody>

 

[jproffer]

This is an example. Don't copy my formula or data directly as I had to change the date formats...

Excel 2013/2016

	A	B	C	D
1	5/1/2017	apples, oranges		2
2	5/6/2017	apples, pears
3	6/20/2017	pears, bananas
4	8/8/2017	oranges, apples
5	8/11/2017	bananas, oranges
6	10/15/2017	grapes, apples
7	11-31-17	pears, grapes
8	12/20/2017	bananas, oranges
9	1/3/2018	bananas, pears
10	2/11/2018	pears, apples

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula D1 =COUNTIFS(A:A,">=5/01/2017",A:A,"<=5/31/2017",B:B, "*apples*") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

But assuming that's the result you want (2), then:

=COUNTIFS(A:A,">=01/05/2017",A:A,"<=31/05/2017",B:B, "*apples*")

try that .

You were missing a closing parenthesis.