COUNTIF based on 2 criteria (1 being dates)

[gjs1985]

Hi,

So here is an example spreadsheet similar to one that I'm working on:



My issue is regarding the output in rows 13-18 and what I'm struggling to do in particular is figure out what formula I need to put into the highlighted cell B14 to produce the expected result shown (once I know this I should easily be able to manipulate it for the rest).

From my research so far, I'm wondering if it may be a combination of the COUNTIF and SUMPRODUCT formulas but I'm fresh out of ideas and now starting to doubt if it's even possible.

Any advice at all would be very helpful and gratefully received.

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C
1
2		12/01/2022	John Smith
3		22/06/2021	John Smith
4		21/01/2022	Anna Thompson
5		07/09/2021	John Smith
6		02/11/2021	Anna Thompson
7		12/05/2021	John Smith
8		22/08/2021	Anna Thompson
9		08/06/2020	John Smith
10		17/11/2021	Anna Thompson
11		21/02/2021	Anna Thompson
12
13		John Smith	Anna Thompson
14		1	3
15		1	1
16		2	0
17		0	1
18		1	0
Main

Cell Formulas
Range	Formula
B14:C14	B14	=COUNTIFS($C$2:$C$11,B$13,$B$2:$B$11,"<="&TODAY(),$B$2:$B$11,">="&EDATE(TODAY(),-3))
B15:C15	B15	=COUNTIFS($C$2:$C$11,B$13,$B$2:$B$11,"<"&EDATE(TODAY(),-3),$B$2:$B$11,">="&EDATE(TODAY(),-6))
B16:C16	B16	=COUNTIFS($C$2:$C$11,B$13,$B$2:$B$11,"<"&EDATE(TODAY(),-6),$B$2:$B$11,">="&EDATE(TODAY(),-9))
B17:C17	B17	=COUNTIFS($C$2:$C$11,B$13,$B$2:$B$11,"<"&EDATE(TODAY(),-9),$B$2:$B$11,">="&EDATE(TODAY(),-12))
B18:C18	B18	=COUNTIFS($C$2:$C$11,B$13,$B$2:$B$11,"<"&EDATE(TODAY(),-12))