IF AND & COUNTIF Problem

[N3cTr0]

Good Day,

I'm trying to get this formula to work where it searches completed dates within a range of dates then if the value is true runs a countif to check how many customers are within that range.
Any assistance would be appreciated.
Example below:

Book1
	A	B	C	D	E	F	G
1	Completed Date	Customer Code
2	1/25/2022	CLICKZGRP
3	5/7/2022	CASHBZGRP		Date Ranges
4	11/5/2022	CLICKZGRP		1/1/2022	31/1/2022
5	2/23/2022	SRITEZGRP
6	5/7/2022	CLICKZGRP		Completed Sites			Expected Values
7	4/7/2022	SRITEZGRP		CLICKZGRP	0		1
8		SRITEZGRP		CASHBZGRP	0		0
9		PNPZGRP		SRITEZGRP	0		0
10	1/25/2022	PNPZGRP		PNPZGRP	0		1
11		SPECIZGRP		SPECIZGRP	0		1
12	1/12/2022	SPECIZGRP
Sheet1

Cell Formulas
Range	Formula
E7:E11	E7	=IF(AND(A:A>$D$4,A:A<E4),COUNTIF(B:B,D7),0)

 

[dreid1011]

Perhaps this:

=COUNTIFS($A$2:$A$12,">="&$D$4,$A$2:$A$12,"<="&$E$4,$B$2:$B$12,$D7)

I had to normalize the dates to work for me, but after that it produced the results as your expected values.

 

[N3cTr0]

Thank you kindly, just realized my 1 date was off that i was comparing against thx m and your formula works perfectly

 

[dreid1011]

Thank you kindly, just realized my 1 date was off that i was comparing against thx m and your formula works perfectly

You're welcome.