CountIFS Name appears between two dates

[Ghtdd]

Hi everyone,

I am trying to use CountIFS to count the total number of times a name appears between two dates (for example each month) in a database. I have attached a scaled down and simplified version below.

My current formula is:=CountIFS($A$2:$A$12,”>”&E$8,$A$2:$A$12,”<“&E$9,$B$2:$B$12,TEXT($D2,1))

Many thanks!

 

[Fluff]

Hi & welcome to MrExcel.
Try

 =CountIFS($A$2:$A$12,">"&E$8,$A$2:$A$12,"<"&E$9,$B$2:$B$12,$D2)

 

[Ghtdd]

Hi & welcome to MrExcel.
Try

 =CountIFS($A$2:$A$12,">"&E$8,$A$2:$A$12,"<"&E$9,$B$2:$B$12,$D2)

Amazing, thank you for taking the time to help me!

 

[Fluff]

You're welcome & thanks for the feedback.