Afternoon Excel Members,

We have a yearly inventory tracker that was created by a past employee. The inventory track keeps record of the properties we get in certain states in certain date ranges.

These are the formulas previously used in the 2014 tracker:
=SUMPRODUCT(--(Table3[State]="co"),--(Table3[Date FSM Assigned]>=$B5),--(Table3[Date FSM Assigned]<$B6))
=SUMPRODUCT(--(Table3[State]="nm"),--(Table3[Date FSM Assigned]>=$B5),--(Table3[Date FSM Assigned]<$B6))
=SUMPRODUCT(--(Table3[State]="tx"),--(Table3[Date FSM Assigned]>=$B5),--(Table3[Date FSM Assigned]<$B6))
=SUMPRODUCT(--(Table3[State]="ut"),--(Table3[Date FSM Assigned]>=$B5),--(Table3[Date FSM Assigned]<$B6))
=SUMPRODUCT(--(Table3[State]="mi"),--(Table3[Date FSM Assigned]>=$B5),--(Table3[Date FSM Assigned]<$B6))

Our new 2015 tracker is on a completely new excel workbook. I tried carrying over the previous years formulas to read from table1 over table3 but I get a bunch of errors.

For the 2015 tracker, all of the new property data is on a 2nd sheet within table1.

My goal is to have the SUMPRODUCT formula count how many properties we have acquired in each specific state within each month's time frame. The state is located in column E of table1, the date acquired is in column S of table1.

Appreciate your advice and help in advance.

Tracker Image.jpg
Data Image.jpg