Countifs and date range

[jwgreen1986]

Wondering if someone could look at the formula and help me. You can pretty much ignore everything up until where i am trying to get it to count the values between 2 dates. i know the formula works before i put the data range criteria in.

Basically i had it working up until where Sales!R:R,"New. i now want to change the formula so it adds up the totals when the delivery date (Sales!H:H) is more than or equal 01/01/2019 but less than 01/02/2019. i have also tried manually putting the dates into a field and referencing the formula to these fields to no avail.

=IF(OR(B4=""),"",IF(OR(B4="New",B4="Combined"), COUNTIFS(Sales!Q:Q,"YES",Sales!S:S,A4,Sales!R:R,"New",Sales!H:H,">=01/01/2019",Sales!H:H,"<01/02/2019")))

 

[DanteAmor]

Sheet1

Excel Workbook
	A	B	C
1
2
3
4	Some	New	3
Sheet

Sheet: Sales

Excel Workbook
	A	H	P	Q	R	S
1
2
3
4		01-ene		YES	New	Some
5		02-ene		NO
6		03-ene		YES	New	Some
7		04-ene		NO
8		05-ene		YES	New	Some
9		06-ene		NO
10		07-ene		YES	New	y
11		08-ene		NO
12		09-ene		YES	x	y
13		10-ene		NO
14		11-ene		YES	x	y
Sheet

 

[jwgreen1986]

hi,

tried this and it is bringing back 0's for everyone. any suggestions?

 

[DanteAmor]

You have to put the data exactly as they are in the example.