multiple condition count if with date range

[Saniphor]

I am trying to write a formula that will count the number of invoices for a given region (state, etc) within a period.

The formula I currently have counts for the entire range not for the specified month.

=COUNTIF(Data!$J$2:$J$4000,Sheet2!$A5)*AND(SUMPRODUCT(NOT(ISBLANK(Data!$A$2:$A$4000))*(MONTH(Data!$A$2:$A$4000)=1)))

 

[Aladin Akyurek]

Try something like...

=SUMPRODUCT(--(DateRange>=StartDate),--(DateRange<=EndDate),--(RegionRange=Region))