Countifs one of the arguments is month and year???

[Tonyd789]

Hi I'm using a countifs function where there are 3 arguments.

One of the arguments i'm asking it to look at is a date and if it falls in a certain month and year then it counts it as long as the other arguments also qualify, how do i go about writing this into my formula?

Any and all help will be greatly appreciated.

Regards

 

[Peter_SSs]

You can do it with COUNTIFS as shown in D2, but I would normally swap to sumproduct as in D3

Excel Workbook
	A	B	C	D
1
2	a	1/07/2018		2
3	a	14/07/2018		2
4	a	27/07/2018
5	a	9/08/2018
6	a	22/08/2018
7	a	4/09/2018
8	a	17/09/2018
9	b	1/07/2018
10	b	14/07/2018
11	b	27/07/2018
12
Count in month & year

 

[Tonyd789]

Thats great thank you Peter.

I went with the sumproduct version.

 

[Peter_SSs]

Thats great thank you Peter.

I went with the sumproduct version.

Cheers.

Just be aware that the COUNTIFS is considerably more efficient, so if you have a very large amount of data (like many tens of thousands of rows) and/or a very large number of these formulas on your sheet there may eventually be a noticeable performance issue and you might be better to use the COUNTIFS.