Counting occurrences based on 2 criteria, one being dates

[Trocks]

Hi all,

Trying to count the number of occurrences a value appears in a col. based on value and if it occurs in a specific month:

Variables:
A1 = apple
A2 = July
Data:
A3 = apple, b3 = 07/01/2017
A4 = apple, b4 = 08/01/2017

Result should be 1.

I've been trying CountiIfs with Month, but no joy. Seems easy enough, but I'm stumped!

 

[Aladin Akyurek]

Try:

=COUNTIFS(A4:A5,A1,B4:B5,">="&(1&A2),B4:B5,"<="&EOMONTH(1&A2,0))

 

[Trocks]

Brilliant! Thanks so much Aladin!!

 

[Aladin Akyurek]

Brilliant! Thanks so much Aladin!!

You are welcome.